Skip to content

Glossary: PostgreSQL Beyond the Basics

PgBouncer, pool modes

Also written: PgBouncer, pool mode, pool_mode, session mode, transaction mode, statement mode, connection pooling, pgbouncer.ini

PgBouncer is a connection pooler that lets many clients share a few real server connections. The pool mode sets when a client gives its connection back: session (on disconnect), transaction (the usual choice) or statement.

Where the book teaches it

Related terms

Prepared statementmax_connectionsSHOW POOLS