PgBouncer is useful, important, and fraught with peril

This post digs into every Postgres feature that does not work in PgBouncer transaction mode and what the implications are, an overview of connection pooling in general, and how connection pooling modes work in PgBouncer and other poolers.