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.