Transaction Pooling: The Multi-Tenant Nightmare

Jun 8, 2025 · 6 min read · This critique of Transaction Pooling in PgBouncer targets multi-tenant PostgreSQL setups that rely on session-level state (e.g., schema-per-tenant using search_path). Because Transaction Pooling discards session state after each transaction, it cause...