On 10/18/2011 06:57 AM, Deshpande, Yogesh Sadashiv (STSD-Openview) wrote:
Hello ,
We have a setup where in there are around 100 process running in
parallel every 5 minutes and each one of them opens a connection to
database. We are observing that for each connection , postgre also
created on sub processes. We have set max_connection to 100. So the
number of sub process in the system is close to 200 every 5 minutes. And
because of this we are seeing very high CPU usage. We need following
information
1.Is there any configuration we do that would pool the connection
request rather than coming out with connection limit exceed.
Yes you need a pooler. Initiating connections like that is expensive.
The use of PgBouncer is your friend here.
http://wiki.postgresql.org/wiki/PgBouncer
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
