From: Guillaume Smet <guillaume.smet@openwide.fr>
To: Ron <rjpeace@earthlink.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: weird performances problem
Date: Tue, 22 Nov 2005 16:26:17 +0100
Message-ID: <43833899.5080408@openwide.fr> (raw)
In-Reply-To: <6.2.5.6.0.20051122093227.040fd900@earthlink.net>
References: <437CC21D.8070402@openwide.fr>
<dlugsf$25o5$1@news.hub.org>
<4382EB58.3020804@openwide.fr>
<6.2.5.6.0.20051122074454.040fae60@earthlink.net>
<43832AA3.6080606@openwide.fr>
<6.2.5.6.0.20051122093227.040fd900@earthlink.net>
Ron,
First of all, thanks for your time.
> As has been noted many times around here, put the WAL on its own
> dedicated HD's. You don't want any head movement on those HD's.
Yep, I know that. That's just we supposed it was not so important if it
was nearly a readonly database which is wrong according to you.
> _Something_ is doing long bursts of write IO on sdb and sdb1 every 30
> minutes or so according to your previous posts.
It's not every 30 minutes. It's a 20-30 minutes slow down 3-4 times a
day when we have a high load.
Anyway apart from this problem which is temporary, we have cpu idle all
the day when we don't have any io wait (and nearly no write) and the
server is enough loaded to use all the 4 cpus. I don't think it's normal.
It's not a very good idea but do you think we can put fsync to off
during a few minutes to check if the WAL is effectively our problem? A
simple reload of the configuration seems to take it into account. So can
we disable it temporarily even when the database is running?
If it is the case, I think we'll test it and if it solved our problem,
we'll ask our customer to buy two new disks to have a specific RAID 1
array for the pg_xlog.
> That's actually a reasonably high CS rate. Again, why?
I'm not so surprised considering what I read before about Xeon
multiprocessors, pg 7.4 and the famous context switch storm. We are
planning a migration to 8.1 to (hopefully) solve this problem. Perhaps
our problem is due to that high CS rate.
--
Guillaume
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: guillaume.smet@openwide.fr, rjpeace@earthlink.net
Subject: Re: weird performances problem
In-Reply-To: <43833899.5080408@openwide.fr>
* 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