The linked blogpost is an interesting read, too, comparing well-tuned pgvector to pinecone:

https://www.tigerdata.com/blog/pgvector-vs-pinecone