You are helping an internal platform team choose the retrieval layer for an enterprise RAG system. The team expects mixed workloads, including semantic search over policy docs, filtered lookup over metadata, and frequent index updates from multiple business units.
How would you compare Pinecone, Weaviate, pgvector, and Elasticsearch for this RAG system, and what would you recommend?