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

From: Karl Denninger <karl(at)denninger(dot)net>
To: Fernando Hevia <fhevia(at)ip-tel(dot)com(dot)ar>
Cc: "'Shiva Raman'" <raman(dot)shivag(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Date: 2009-09-23 20:52:01
Message-ID: 4ABA8A71.6010503@denninger.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Fernando Hevia wrote:
>>>> 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.
>
>
I can second this - I have an EXTREMELY busy forum system using pgpool
and during peak hours it runs very well within around 100 connections in
use.

-- Karl

Attachment Content-Type Size
karl.vcf text/x-vcard 124 bytes

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jared Beck 2009-09-23 20:53:15 Slow query after upgrade to 8.4
Previous Message Fernando Hevia 2009-09-23 20:50:08 Re: High CPU load on Postgres Server during Peak times!!!!