From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "List, Postgres" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: max_connections proposal |
Date: | 2011-05-26 23:22:14 |
Message-ID: | 4DDEE0A6.3090107@postnewspapers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 05/26/2011 09:48 PM, Tom Lane wrote:
> Craig Ringer<craig(at)postnewspapers(dot)com(dot)au> writes:
>> max_connections = 100 # (change requires restart)
>> # WARNING: If you're about to increase max_connections above 100, you
>> # should probably be using a connection pool instead. See:
>> # http://wiki.postgresql.org/max_connections
>
> This gives the impression that performance is great at 100 and falls off
> a cliff at 101, which is both incorrect and likely to lower peoples'
> opinion of the software.
Fair call; the use of a specific value is misleading.
> I'd suggest wording more like "if you're
> considering raising max_connections into the thousands, you should
> probably use a connection pool instead".
Best performance is often obtained with the number of _active_
connections in the 10s to 30s on commonplace hardware. I'd want to use
"hundreds" - because mailing list posts etc suggest that people start
running into problems under load at the 400-500 mark, and more
importantly because it's well worth moving to pooling _way_ before that
point.
> And I agree with Merlin that a
> wiki pointer is inappropriate.
That does make sense.
--
Craig Ringer
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-05-26 23:30:54 | Re: max_connections proposal |
Previous Message | Tarlika Elisabeth Schmitz | 2011-05-26 21:45:43 | Re: trigger - dynamic WHERE clause |