What are the most common vector database challenges?

Vector search works great in development. Queries return relevant results, the demo impresses stakeholders, and you're ready to ship. Then production happens. Memory costs balloon, search quality...