May 2018
Intermediate to advanced
576 pages
30h 25m
English
PgBouncer is a great piece of software. Its feature set is very carefully defined to ensure that it is simple, robust, and very fast. PgBouncer is not multithreaded, so it runs in a single process, and thus, on a single CPU. It is very efficient, but very large data transfers will take more time and reduce concurrency, so create those data dumps using a direct connection.
PgBouncer provides connection pooling. If you set pool_mode = transaction, then PgBouncer will also provide connection concentration. This allows hundreds or even thousands of incoming connections to be managed, while only a few server connections are made.
As new connections, transactions, or statements arrive, the pool will increase in size up to the user-defined ...