Transaction Pooling: The Multi-Tenant Nightmare

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...