[pgpool-general: 312] How does PGPool do Connection Caching...
Matt Wise
matt at nextdoor.com
Tue Mar 27 23:58:57 JST 2012
Could somebody explain how PGPool handles connection caching? The PGBouncer docs describe in reasonable detail how it works, how connections are selected, how they die off, etc... its useful in understanding how to tweak the PGBouncer settings.
I'm curious whether PGPool uses a LIFO or FIFO method ... or is it round-robin.. etc. How does it handle having 1000 clients, but say only 100 bcakend DB connections.. what happens when there are more transaction requests than available connections, etc?
—Matt
More information about the pgpool-general
mailing list