mitdbg/pgvectorfast: High-performance vector similarity search enhancement for PostgreSQL

github.com3 min read

pgvectorfast is a high-performance drop-in enhancement for PostgreSQL's pgvector extension that accelerates vector similarity search and analytical queries using the Calico buffer pool. The extension replaces PostgreSQL's default buffer manager with array-based page translation, lock-free optimistic reads, and workload-aware group prefetch to eliminate concurrency bottlenecks during HNSW graph traversal. It maintains complete SQL and on-disk compatibility with existing pgvector data types and index types on PostgreSQL 18 and 19. Open article →