From: Ivan Voras <ivoras@freebsd.org>
To: pgsql-performance@postgresql.org
Subject: Re: High load,
Date: Fri, 28 Jan 2011 15:06:07 +0100
Message-ID: <ihuigg$1mp$1@dough.gmane.org> (raw)
In-Reply-To: <AANLkTikBFzUKmWcVBz_5GQZeQOWtj7Kfeov=M9TWBOJf@mail.gmail.com>
References: <AANLkTikBFzUKmWcVBz_5GQZeQOWtj7Kfeov=M9TWBOJf@mail.gmail.com>
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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ivoras@freebsd.org
Subject: Re: High load,
In-Reply-To: <ihuigg$1mp$1@dough.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox