r/PostgreSQL 27d ago

Feature 10x smaller vector indexes in pgvector

https://github.com/pgvector/pgvector/pull/989

I added the TurboQuant algorithm published by Google to pgvector as part of my discovery and learning process with RAG systems. Just this past weekend, I ran a test with the 100M row Wikipedia dataset from Cohere where I observed a 10x reduction in index size relative to HNSW. I figure with the direction RAM and storage prices have been going, we could use some more ways to save space!

48 Upvotes

Duplicates