Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 2F909EA0906
	for <pgsql-admin@postgresql.org>; Wed, 25 Jan 2012 01:16:10 -0400 (AST)
Received: from rs133.luxsci.com ([72.32.115.26])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gnanam@zoniac.com>) id 1RpvDL-0004KS-Lx
	for pgsql-admin@postgresql.org; Wed, 25 Jan 2012 05:16:09 +0000
Received: from GNANAM (NSG-Static-233.156.72.182.airtel.in [182.72.156.233]
	(may be forged)) (authenticated bits=0)
	by rs133.luxsci.com (8.13.8/8.13.8) with ESMTP id q0P5Ev8S019245;
	Tue, 24 Jan 2012 23:15:52 -0600
Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: <pgsql-admin@postgresql.org>
Subject: Parameters to consider on increasing max_connections and physical
	memory
Date: Wed, 25 Jan 2012 10:35:55 +0530
Organization: Zoniac Software Private Limited
Message-ID: <004d01ccdb1f$06f8cea0$14ea6be0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AczbHwQTbLfgXorKREmFCBh+SX4NeA==
Content-Language: en-us
X-Lux-Comment: Message q0P5Ev8S019245 sent by user #22393
X-Pg-Spam-Score: 0.8 (/)
X-Archive-Number: 201201/137
X-Sequence-Number: 39049

Hi,

Our Production server is running PostgreSQL v8.2.22 on CentOS5.2.  Based on
the application usage trend, we're finding that we need to increase maximum
number of concurrent connections to the database server, that is
"max_connections" parameter.  Of course, I also understand that it requires
more system physical memory.

My question is, what are all the PostgreSQL conf parameters that I must take
into account/consider to adjust/modify, if we increase system physical
memory and "max_connections"?

Regards,
Gnanam