Building a RAG app and confused about vector DB choice

Pinecone seems most popular but managed only

Weaviate and Qdrant have open source options

What actually works better? Need good similarity search performance