On: Show HN: I put PubMed in a vector DB

[alex_duf]

What storage did you go for, and what search approach?

[mpmisko → alex_duf]

We use pinecone and it is not ideal, looking at https://turbopuffer.com/ now. They look quite promising :)

[yumraj → mpmisko]

Did you compare pinecone against pgvector with Postgres? Self hosted of course

[cchance → yumraj]

Isn't it funny how the best Choice somehow always comes back to Postgres in the end XD (for most)

[yumraj → cchance]

Yes, that’s where I’m these days. I don’t even think of venturing outside of Postgres these days, except for say things like Redis etc. where there are mature and established options for specific use cases.

[mpmisko → yumraj]

Will definitely check pgvector, thanks for the pointer.

[cchance → mpmisko]

What kinda dimensions did you keep it relatively low to keep costs down?