Re: High SYS CPU - need advise

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Vlad" <marchenko(at)gmail(dot)com>,"Merlin Moncure" <mmoncure(at)gmail(dot)com>
Cc: "Jeff Janes" <jeff(dot)janes(at)gmail(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: High SYS CPU - need advise
Date: 2012-11-24 20:30:49
Message-ID: 20121124203049.297020@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Flower 2012-11-24 21:17:37 Re: High SYS CPU - need advise
Previous Message Jeff Janes 2012-11-24 20:25:30 Re: Restore postgres to specific time