Re: High CPU load on Postgres Server during Peak times!!!!

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: "'Shiva Raman'" <raman(dot)shivag(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Date: 2009-09-23 20:50:08
Message-ID: 5729299F62164F698F9575674E31F5C8@iptel.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>>
>>> User Access
>>> Total Number of Users is 500
>>> Maximum number of Concurrent users will be 500 during peak time
>>> Off Peak time the maximum number of concurrent user will be
>>> around 150 to 200.
>>>
>>
>>A connection pooler like pgpool or pgbouncer would considerably reduce the
>>burden on your system.
>>
>
>I am already using connection pooling in tomcat web server, so installing
pgpool
>will help enhancing the performance ?Any changes i have to do in my
application to
>include pgpool?
>

There shouldn't be need for another pooling solution.
Anyway, you probably dont want 1800 concurrent connections on your database
server, nor even get near that number.

Check the number of actual connections with:
select count(*) from pg_stat_activity;

A vmstat run during high loads could provide a hindsight to if the number of
connections is straining your server.

If the number of connections is high (say over 200-300), try reducing the
pool size in Tomcat and see what happens.
You possibly could do fine with something between 50 and 100 connections.

Regards,
Fernando.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Karl Denninger 2009-09-23 20:52:01 Re: High CPU load on Postgres Server during Peak times!!!!
Previous Message Andy Colson 2009-09-23 18:53:14 Re: High CPU load on Postgres Server during Peak times!!!!