defog sqlcoder 70b alpha needs about 44.6 GB of memory at Q4_K_M (a 41.4 GB file) with an 8K context window, so it fits on a 48 GB GPU. This repository has 19 quants, from 25.5 GB (Q2_K) to 73.3 GB (Q8_0).
defog sqlcoder 70b alpha is a 69B-parameter Defog model in GGUF format, quantized by RichardErkhov. Its trained context length is 16K tokens. The repository has 19 quant files, from 25.5 GB (Q2_K) to 73.3 GB (Q8_0).
Quants & memory
| Quant | File | Est. memory | vs VRAM | Result | |
|---|---|---|---|---|---|
| Q2_K | 25.5 GB | 28.6 GB | Too big | Get file → | |
| Q3_K_S | 29.9 GB | 33.1 GB | Too big | Get file → | |
| Q3_K | 33.3 GB | 36.5 GB | Too big | Get file → | |
| Q3_K_M | 33.3 GB | 36.5 GB | Too big | Get file → | |
| Q3_K_L | 36.1 GB | 39.3 GB | Too big | Get file → | |
| IQ4_XS | 37.2 GB | 40.4 GB | Too big | Get file → | |
| Q4_0 | 38.9 GB | 42.1 GB | Too big | Get file → | |
| IQ4_NL | 39.2 GB | 42.4 GB | Too big | Get file → | |
| Q4_K_S | 39.2 GB | 42.4 GB | Too big | Get file → | |
| Q4_K | 41.4 GB (2 parts) | 44.6 GB | Too big | Get file → | |
| Q4_K_M | 41.4 GB (2 parts) | 44.6 GB | Too big | Get file → | |
| Q4_1 | 43.2 GB (2 parts) | 46.4 GB | Too big | Get file → | |
| Q5_0 | 47.5 GB (2 parts) | 50.6 GB | Too big | Get file → | |
| Q5_K_S | 47.5 GB (2 parts) | 50.6 GB | Too big | Get file → | |
| Q5_K | 48.8 GB (2 parts) | 51.9 GB | Too big | Get file → | |
| Q5_K_M | 48.8 GB (2 parts) | 51.9 GB | Too big | Get file → | |
| Q5_1 | 51.8 GB (2 parts) | 54.9 GB | Too big | Get file → | |
| Q6_K | 56.6 GB (2 parts) | 59.8 GB | Too big | Get file → | |
| Q8_0 | 73.3 GB (2 parts) | 76.5 GB | Too big | Get file → |
What GPU do you need for defog sqlcoder 70b alpha?
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: no quant fits at an 8K context.
- 16 GB VRAM: no quant fits at an 8K context.
- 24 GB VRAM: no quant fits at an 8K context.
- 32 GB VRAM: the best quant that fits is Q2_K (25.5 GB file, about 28.6 GB in use).
- 48 GB VRAM: the best quant that fits is Q4_1 (43.2 GB file, about 46.4 GB in use).
Which defog sqlcoder 70b alpha quant should you choose?
Q4_K_M is the usual starting point for defog sqlcoder 70b alpha: it balances file size and quality well. Here it is a 41.4 GB file.
The Q8_0 file is 73.3 GB, about 1.8 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.
If memory is tight, the smallest file is Q2_K at 25.5 GB, with the quality trade-offs that come with fewer bits. Use it only when memory is very tight. Expect a clear drop in quality, which is usually worse on small models and easier to live with on large ones.
New to quant names? Read GGUF quantization explained.
Specifications
Architecture from the GGUF header
Source
Frequently asked questions about defog sqlcoder 70b alpha
How much VRAM does defog sqlcoder 70b alpha need?
About 44.6 GB at Q4_K_M with an 8K context window. That is the 41.4 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 defog sqlcoder 70b alpha on an 8 GB GPU?
Not at an 8K context. The smallest file needs about 28.6 GB, so you would need a larger GPU or CPU offloading.
What is the file size of defog sqlcoder 70b alpha GGUF?
It depends on the quant: Q2_K is 25.5 GB, Q3_K_S is 29.9 GB, Q3_K is 33.3 GB, Q3_K_M is 33.3 GB, Q3_K_L is 36.1 GB, IQ4_XS is 37.2 GB and 13 more.
What context length does defog sqlcoder 70b alpha support?
The GGUF header lists a trained context length of 16,384 tokens (16K). The KV cache grows with the context you use: about 2.7 GB at 8K and 5.4 GB at 16K.
Where can I download defog sqlcoder 70b alpha GGUF?
The files are on Hugging Face in the RichardErkhov/defog_-_sqlcoder-70b-alpha-gguf repository. The download buttons on this page open the file on Hugging Face. ggufmodels.com does not host any model files.
What license does defog sqlcoder 70b alpha use?
Hugging Face lists the license as cc-by-sa-4.0. Licenses can differ between the quantized files and the original model, so check the repository and the base model before commercial use.