This post maps every item on the PgBouncer compatibility table to more information about their impact, and provides info on how PgBouncer modes and connection pooling work.
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.