On 1/7/2016 10:32 PM, Sachin Srivastava wrote:
We are looking at more like 500-600 connections simultaneously in 1 day and I want to say we get 10000 to 12000 connections a day per db.
these applications, are they hammering queries, or mostly idle, and just issuing intermittent queries?
500 queries at the same time will cause serious resource thrashing with 32 cores. if they are mostly idle, you should look at the pgbouncer style connection pooling model, as Ben suggests
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
