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

From Kevin Grittner
Subject Re: High SYS CPU - need advise
Date
Msg-id 20121124203049.297020@gmx.com
Whole thread Raw
In response to High SYS CPU - need advise  (Vlad <marchenko@gmail.com>)
Responses Re: High SYS CPU - need advise  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Restore postgres to specific time
Next
From: Gavin Flower
Date:
Subject: Re: High SYS CPU - need advise