PostgreSQL Transaction Pooling Breaks Prepared Statements: PgBouncer vs AWS RDS Proxy Under 20,000 Payday Concurrency
When payday spikes hit 20,000 concurrent database connections, raw PostgreSQL chokes on process memory. Switching to PgBouncer transaction pooling solves the memory leak but breaks ORM prepared statements—here is how to engineer around error 42P05 without paying AWS RDS Proxy tax.