[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