max_connections

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: max_connections
Date: 2005-08-29 17:59:16
Message-ID: 5c420b4517009f2ae9c0214f9851794d@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've recently succeeded in lobbying my sysadmins to upgrade from 7.2.0
to 7.4.8 (thanks to everyone for the advice on how to leverage this).
I'm now fiddling with some of the performance parameters, and I'm
wondering about max_connections. The default appears to be 100 - this
is at least an order of magnitude higher than I need. Would much be
saved by dropping this down to 10 or less? I gather I could dial
shared_buffers up slightly (SHMMAX is 32M on our Solaris boxes), but is
there any substantive benefit to conservatively setting
max_connections?

Thanks.

- John D. Burger
MITRE

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-29 18:00:54 Re: About dropped notifications
Previous Message CSN 2005-08-29 16:58:38 About dropped notifications