New open-source index PRISM claims to beat pgvector's IVFFlat and HNSW
Developers have released PRISM, an alpha-stage PostgreSQL index access method built in C that targets approximate nearest neighbor search. It combines hierarchical centroid routing, RaBitQ quantization and SIMD-optimized distance calculations, and supports dynamic inserts, updates and deletes alongside existing pgvector columns.