What’s your workflow for vector DB benchmarking in production?

Context: I'm working on agents 016 and ran into a decision point.

• What I’ve tried: basic setup + quick benchmarks.
• Constraints: limited time, want something stable.

Question: What’s your workflow for vector DB benchmarking in production?

Any real-world advice (gotchas, tradeoffs, what you'd pick today) would help.