I was tinkering with pgvector recently but I was getting inconsistent results. Sometimes Postgres just failed to use the index and resorted to a brute force sea

I was tinkering with pgvector recently but I was getting inconsistent results. Sometimes Postgres just failed to use the index and resorted to a brute force search which is very slow. Sometimes the index worked and IIRC I managed to sort 500K vectors (limit=10 or so) with dimension size 1536 in about 80ms which is okay but not state of the art. I was using an artificial dataset which might have biased the index statistics resulting in poor execution. Mind you that this was all running in WSL and I'm very new to vector search so I might not know what I'm doing.