[hobofan]

> When you have 100,000 vectors [...] and they'll work fine

So 95% of use-cases.

[Jnr]

I think Immich (Google photos alternative) uses pgvector. And while you can't really call it a "production" system, because it is self hosted, I have about 100,000 assets there and the vector search works great!

[samus]

In that case you might not even really need optimized vector search though.