Horton

Re: BUG #19114: ORDER BY ASC is tampering result when calculating distance btw vectors

Thomas Munro <thomas.munro@gmail.com>

View thread
From: Thomas Munro <thomas.munro@gmail.com>
To: naveenkrishna.s@sky.uk, pgsql-bugs@lists.postgresql.org
Date: 2025-11-17T07:50:45Z
Lists: pgsql-bugs 
On Mon, Nov 17, 2025 at 7:14 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
> 40 records

Sounds like pgvector[1]?

"Why are there less results for a query after adding an HNSW index?
Results are limited by the size of the dynamic candidate list
(hnsw.ef_search), which is 40 by default. ...."

[1] https://github.com/pgvector/pgvector