A customer needed semantic search over 20 million embeddings. Their first attempt timed out. Three changes turned it into sub-200ms queries. Here's what we learned.

Analytics queries and transactional queries compete for the same I/O, memory, and connections in Postgres. Here's how to isolate them — and when to stop fighting the architecture.