News for hackers. Stuff that matters.
Re:The Case Against PGVector by IntrepidPig on Monday November 03, 2025 @11:49AM (#45801152)
> Post-filter works when your filter is permissive. Here’s where it breaks: imagine you ask for 10 results with LIMIT 10. pgvector finds the 10 nearest neighbors, then applies your filter. Only 3 of those 10 are published. You get 3 results back, even though there might be hundreds of relevant published documents slightly further away in the embedding space.

Is this really how it works? That seems like it’s returning an incorrect result.

There are no comments on this comment yet.