Your primary PostgreSQL database is approaching its capacity limits with growing read and write traffic. Design a comprehensive scaling strategy that addresses both immediate relief and long-term growth.

Sample answer preview

Scaling a PostgreSQL database requires a multi-layered strategy because databases are stateful systems where horizontal scaling is significantly more complex than scaling stateless application tiers.