Parameters to consider on increasing max_connections and physical memory

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Parameters to consider on increasing max_connections and physical memory
Date: 2012-01-25 05:05:55
Message-ID: 004d01ccdb1f$06f8cea0$14ea6be0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2012-01-25 09:06:19 Re: Parameters to consider on increasing max_connections and physical memory
Previous Message Simon Riggs 2012-01-23 20:53:29 Re: two questions regarding warm-standby on 8.4