GE

gemma 2 9b Instruct NL2SQL

GemmaGGUF by makiisthebesUpdated 2024-12-15
Download on Hugging Face
Parameters9.24B
Context8K
Layers42
Architecturegemma2
Smallest quant5.8 GB
Quick answer

gemma 2 9b Instruct NL2SQL needs about 9.1 GB of memory at Q4_K_M (a 5.8 GB file) with an 8K context window, so it fits on a 12 GB GPU. This repository has 3 quants, from 5.8 GB (Q4_K_M) to 9.8 GB (Q8_0).

gemma 2 9b Instruct NL2SQL is a 9.24B-parameter Gemma model in GGUF format, quantized by makiisthebes. Its trained context length is 8K tokens. The repository has 3 quant files, from 5.8 GB (Q4_K_M) to 9.8 GB (Q8_0).

Quants & memory

QuantFileEst. memoryvs VRAMResultDownload
Q4_K_M5.8 GB 9.1 GB
Too big Get file →
Q5_K_M6.6 GB 10.0 GB
Too big Get file →
Q8_09.8 GB 13.1 GB
Too big Get file →

What GPU do you need for gemma 2 9b Instruct NL2SQL?

These figures add the file size, an fp16 KV cache at an 8K context window (worked out from this model’s own header) and about 0.5 GB for the runtime. They are estimates, so leave a little headroom, and expect to use less context or a smaller quant if you are right at the limit.

  • 4 GB VRAM: no quant fits at an 8K context.
  • 6 GB VRAM: no quant fits at an 8K context.
  • 8 GB VRAM: no quant fits at an 8K context.
  • 12 GB VRAM: the best quant that fits is Q5_K_M (6.6 GB file, about 10.0 GB in use).
  • 16 GB VRAM: the best quant that fits is Q8_0 (9.8 GB file, about 13.1 GB in use).

Which gemma 2 9b Instruct NL2SQL quant should you choose?

Q4_K_M is the usual starting point for gemma 2 9b Instruct NL2SQL: it balances file size and quality well. Here it is a 5.8 GB file.

The Q8_0 file is 9.8 GB, about 1.7 times the size of Q4_K_M. It keeps the weights closer to the original, which only matters if you have the memory to spare.

New to quant names? Read GGUF quantization explained.

Specifications

Architecture from the GGUF header

Architecturegemma2
Parameters9.24B
Layers42
Trained context8,192 tokens
KV cache (fp16)336 KB per token

Source

Quantized bymakiisthebes
FamilyGemma
Licenseapache-2.0
Downloads (HF)48
Last updated2024-12-15

Frequently asked questions about gemma 2 9b Instruct NL2SQL

How much VRAM does gemma 2 9b Instruct NL2SQL need?

About 9.1 GB at Q4_K_M with an 8K context window. That is the 5.8 GB file, plus the KV cache and roughly 0.5 GB of runtime overhead. Smaller quants need less and longer context needs more.

Can I run gemma 2 9b Instruct NL2SQL on an 8 GB GPU?

Not at an 8K context. The smallest file needs about 9.1 GB, so you would need a larger GPU or CPU offloading.

What is the file size of gemma 2 9b Instruct NL2SQL GGUF?

It depends on the quant: Q4_K_M is 5.8 GB, Q5_K_M is 6.6 GB, Q8_0 is 9.8 GB.

What context length does gemma 2 9b Instruct NL2SQL support?

The GGUF header lists a trained context length of 8,192 tokens (8K). The KV cache grows with the context you use: about 2.8 GB at 8K and 2.8 GB at 8K.

Where can I download gemma 2 9b Instruct NL2SQL GGUF?

The files are on Hugging Face in the makiisthebes/gemma-2-9b-Instruct-NL2SQL repository. The download buttons on this page open the file on Hugging Face. ggufmodels.com does not host any model files.

What license does gemma 2 9b Instruct NL2SQL use?

Hugging Face lists the license as apache-2.0. Licenses can differ between the quantized files and the original model, so check the repository and the base model before commercial use.

Other GGUFs of gemma-2-9b-it-bnb-4bit

Similar models

Browse all →

More from makiisthebes

All by makiisthebes →

More Gemma models

All Gemma →

Other small models

All small models →