Skip site navigation (1) Skip section navigation (2)

Re: High load,

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: High load,
Date: 2011-01-28 14:06:07
Message-ID: ihuigg$1mp$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-performance
On 27/01/2011 11:31, Michael Kohl wrote:
> Hi all,
>
> we are running a fairly big Ruby on Rails application on Postgres 8.4.
> Our traffic grew quite a bit lately, and since then we are facing DB
> performance issues. System load occasionally explodes (around 170
> yesterday on a 16 core system), which seems to be caused by disk I/O
> (iowait in our Munin graphs goes up significantly during these
> periods). At other times the laod stays rather low under pretty much
> the same circumstances.

Is there any way you can moderate the number of total active connections 
to the database to approximately match the number of (logical) CPU cores 
on your system? I.e. some kind of connection pool or connection 
limiting? This should help you in more ways than one (limit PG lock 
contention, limit parallel disk IO).



In response to

  • High load, at 2011-01-27 10:31:13 from Michael Kohl

pgsql-performance by date

Next:From: Shaun ThomasDate: 2011-01-28 15:31:10
Subject: Re: FW: Queries becoming slow under heavy load
Previous:From: Grant JohnsonDate: 2011-01-28 13:24:11
Subject: Re: How to best use 32 15k.7 300GB drives?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group