On 10/30/12 12:32 AM, Frank Lanitz wrote:
I was maintaining a setup which had > 1000 connections on a not very high-end server (12GB of Ram). It was just most of the connections were idling most the time. Tomcat with a high number of consistent connections for some reasons and end user stand alone clients which are establishing a database connection on startup and keeping them until shutdown.
a better configuration for that is for your web applications to grab a connection from a connection pool, do a transaction, and then release the connection as soon as you are done. keep the pool size modest, maybe 2-4X the number of CPU cores you have. IF you have some things that do long running queries, like for calculating reports, create a separate smaller pool for these as there likely are only 1-2 of them at a time anyways.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general