seeing comments about using pgvector... at pinecone, we spent some time understanding it's limitations and pain points. pinecone eliminates these pain points entirely and makes things simple at any scale.
check it out: https://www.pinecone.io/blog/pinecone-vs-pgvector/