Pg_vectorsearch: An index that is faster than pgvector's IVFFlat and HNSW
41 points by jascha_eng 2 hours ago | 9 comments
swe_dima 17 minutes ago
Sadly if cloud providers don't offer it on managed postgres then not many people can use it...
replyjascha_eng 2 minutes ago
Well you can always move to tiger cloud if you want it managed :)
And this is PostgreSQL licensed just like our pg_textsearch which has been adopted to Googles AlloyDB and microsofts HorizonDB already, so there is hope!
replyEgregiousCube 28 minutes ago
I'm currently running VectorChord and I love it - with a fast backing disk, it's cut my postgres cost in half. Excited to see competition in low-RAM vector index tools. RAMageddon seems to be creating incentives to find more ways to take advantage of how fast modern nvme drives are!
replyRapzid 51 minutes ago
Does it support filtering though?
replyEdit: post filtering only
I don't understand how people are efficiently implementing tenant/user/permission scopes with these indexes.
jascha_eng 2 hours ago
from the accompanying blog post: https://www.tigerdata.com/blog/announcing-pg_vectorsearch-sc...
reply> TLDR: We are launching pg_vectorsearch, a new open-source PostgreSQL extension that makes vector search dramatically faster and more cost-efficient. Its new PRISM index uses partitioning and compression instead of HNSW's graph-based approach, delivering faster queries with a fraction of the memory and significantly faster index builds. At 100 million vectors, PRISM achieved 6 ms query latency on a machine with 4× less memory than HNSW, with index builds over 20× faster.
esafak 15 minutes ago
Shouldn't you lead with your benchmarks if you're fast? qps and precision/recall, please.
replyjascha_eng 6 minutes ago
benchmarks are in the blog post and the benchmarking suite is also open sourced alongside it.
reply