pgvector Advanced Extension Setup Requires pgvector 0.7+ for halfvec, binary quantization, and sparsevec. Data Types (pgvector 0.7+) | Type | Bytes/dim | Use | |---|---|---| | | 4 | Standard float32 | | | 2 | Half precision, 2x storage win, minor recall loss | | | 1/8 | Binary quantized, Hamming search | | | variable | Sparse (SPLADE, BM25-style) | HNSW vs IVFFlat | Aspect | HNSW | IVFFlat | |---|---|---| | Build time | Slow | Fast | | Query speed | Fast | Fast when tuned | | Recall | Higher | Good | | Memory | High (graph in RAM) | Lower | | Inserts after build | Fine | Ok but recall drifts…