On 8/12/2014 2:41 PM, pinker wrote:
btw. 512MB if we assume up to 600 connection is a reasonable value?
thats an insanely high connection count, if you actually expect those connections to be executing concurrent queries, unless you have something north of 100 CPU cores.
you'd be much better to have a MUCH smaller connection count, and use a connection pooler such as pgbouncer, in transaction mode... let 600 client htreads connect to the pooler, but have the pooler share maybe 4X your CPU core/thread count of actual connections for transactions in progress.
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
