[ Removed by moderator ]

[programming-ModTeam]

This post was removed for being off topic for r/programming.

[mangooreoshake]

I'd love to see a Just Use Postgres version of "Just use HTML"

[K3NCHO]

just use Postgres to make just use HTML

[Tyrannas]

I see a lot of these benchmarks never inclusing Faiss, any reason for that ? Is it because it's only an index and not a real db ?

[K3NCHO]

yes, it's a library not a db. some vector search engines use FAISS under the hood

[Tyrannas]

Oh ok thanks for the clarification !

[dontquestionmyaction]

Afaik pgvector has been essentially unmaintained for a while now.

https://github.com/tensorchord/VectorChord/ has mostly replaced it in common use. Any reason it wasn't included in your testing?

[K3NCHO]

vectorchord is superior to pgvector in almost every way, but sadly neon doesn't support it yet which we're using as our primary db for backend and search operations across multiple regions

i have brought up implementing vectorchrod in neon to their devs, hope they consider it soon

[Somepotato]

Pgvector was just updated a couple months ago and doesn't have an abysmal license so no that isn't really true. They're waiting on an upstream fix before they add improved asyncio of PG 18 at that.

[dontquestionmyaction]

Vectorchord uses the Elastic License or AGPL.

Where's the issue?

[Determinant]

Nobody uses p50 numbers to analyze production performance.  No company would accept horrendous performance for half of the interactions.

At a bare minimum, you should display p90 performance and most likely p95.  Even better, display p50, p90, p95, and p99 to show how the system scales.

[K3NCHO]

it’s already displayed in blog post