Re: High SYS CPU - need advise - Mailing list pgsql-general

From Gavin Flower
Subject Re: High SYS CPU - need advise
Date
Msg-id 50B13971.7090608@archidevsys.co.nz
Whole thread Raw
In response to Re: High SYS CPU - need advise  ("Kevin Grittner" <kgrittn@mail.com>)
Responses Re: High SYS CPU - need advise
List pgsql-general
On 25/11/12 09:30, Kevin Grittner wrote:
> Vlad wrote:
>
>> it's session mode and the pool size is 1200 (cause I need to
>> grantee that in the worst case we have enough slots for all
>> possible clients),
> We found that the real-world production performance of a web
> application servicing millions of we hits per day with thousands of
> concurrent users improved when we reconfigured our database
> connection pool to be about 35 instead of 55, on a 16 core box with a
> 40 drive RAID.
>
> http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
>
> -Kevin
>
>
Curious,  what is your RAID configuration?


Cheers,
Gavin


pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: High SYS CPU - need advise
Next
From: "Kevin Grittner"
Date:
Subject: Re: High SYS CPU - need advise