PostgreSQL DBA

PgBouncer

Question

Transaction pooling versus statement pooling: what differs, and when should each be used?

Answer

Transaction pooling assigns a server through a transaction. Statement pooling returns it after each query and disallows multi-statement transactions. Use transaction pooling for pool-safe transactional applications; use statement pooling for autocommit-style workloads designed for it.

This is 19 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples