Show HN: pg_vectorsearch: Scalable Open-Source Vector Search in PostgreSQL

Category: database

Tags: vector-search, postgresql-extension, ann, simd, quantization

Score: 7.3/10 (Innovation: 7, Technical: 8, Documentation: 7, Utility: 7)

pg_vectorsearch is a PostgreSQL extension implementing a novel PRISM index for approximate nearest neighbor search, combining hierarchical routing, RaBitQ quantization with error bounds, and SIMD-optimized distance computation. It offers significant performance gains over pgvector's IVFFlat and HNSW, supports dynamic updates, and is compatible with existing pgvector tables.

Target audience: backend developers, data engineers, devops

Repository: https://github.com/timescale/pg_vectorsearch · C · PostgreSQL · 402 stars

View on Hacker News