Kobus Wolvaardt wrote:
We have similar connection settings, same app, same DB, same username, same settings. What appart from installing pgpool do you need to do to get it to seamlessly share connections? Do you need to do anything in code? Do a special query to indicate the end of a transaction?
your app would need to be modified to open a connection, use it, and close it before going idle for a long period. it could do this with or without a connection pool, the pool just speeds up the process by keeping the actual database connections open. if you have 200 threads that are idle 95% of the time, you likely wouldn't need more than 20 actual database connections.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
