How to handle analytics workloads in Postgres without slowing down transactions

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.