← Thursday, October 15, 2026DatabasesTool

Pg_vectorsearch adds quantized hierarchical routing for PostgreSQL ANN search

github.com 5 min read Editor score 6/10

The alpha PostgreSQL extension combines hierarchical routing, RaBitQ quantization and SIMD distance calculations for approximate nearest-neighbor indexes, with dynamic updates. It could be worth evaluating for vector-search workloads, but the excerpt provides no comparative benchmark results.

What

• PRISM is a PostgreSQL-native approximate nearest neighbor index for vector search, currently marked alpha and not for production.

How

• It routes through a hierarchical centroid tree, scans posting lists, and uses RaBitQ error bounds to filter candidates before full-precision reranking.

Why it matters

• Its quantization and routing aim to reduce search work and memory needs; the project says it is faster than pgvector's IVFFlat and HNSW.

Read on github.com → Hacker News · 52 comments

Headline, summary, brief and diagram are written by a model from the source's own text; the link, byline and numbers come from the source. Read the original before relying on a claim.