Pg_vectorsearch: An index that is faster than pgvector's IVFFlat and HNSW

Re:Pg_vectorsearch: An index that is faster than pgvector's ... by Rapzid on Wednesday October 14, 2026 @08:20AM (#50086544)

Does it support filtering though?

Edit: post filtering only

I don't understand how people are efficiently implementing tenant/user/permission scopes with these indexes.

[ Parent | on HN ]

Re:Pg_vectorsearch: An index that is faster than pgvector's ... by 3abiton on Wednesday October 14, 2026 @09:23AM (#50087379)

Checks notes, one dayabase per client, per user, per project ... etc

[ Parent | on HN ]

Re:Pg_vectorsearch: An index that is faster than pgvector's ... by qeternity on Wednesday October 14, 2026 @09:33AM (#50087548)

Partitioning is the easy bit I think, and falls out naturally from Postgres.

But how are people doing recency biasing with vector databases?

All of our approaches are either expensive or super hacky.

[ Parent | on HN ]

Re:Pg_vectorsearch: An index that is faster than pgvector's ... by enordstr on Wednesday October 14, 2026 @08:46AM (#50086873)

Multi-column indexes for multi-tenant tables is planned for a future release.

[ Parent | on HN ]

Re:Pg_vectorsearch: An index that is faster than pgvector's ... by esafak on Wednesday October 14, 2026 @08:56AM (#50087011)

LanceDB supports push down and list/array membership through DataFusion.

[ Parent | on HN ]