From: Guillaume Smet <guillaume.smet@openwide.fr>
To: Qingqing Zhou <zhouqq@cs.toronto.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: weird performances problem
Date: Tue, 22 Nov 2005 10:56:40 +0100
Message-ID: <4382EB58.3020804@openwide.fr> (raw)
In-Reply-To: <dlugsf$25o5$1@news.hub.org>
References: <437CC21D.8070402@openwide.fr>
<dlugsf$25o5$1@news.hub.org>
Qingqing Zhou wrote:
> Someone is doing a massive *write* at this time, which makes your query
> *read* quite slow. Can you find out which process is doing write?
Indexes should be in memory so I don't expect a massive write to slow
down the select queries. sdb is the RAID10 array dedicated to our data
so the postgresql process is the only one to write on it. I'll check
which write queries are running because there should really be a few
updates/inserts on our db during the day.
On a four days log analysis, I have the following:
SELECT 403,964
INSERT 574
UPDATE 393
DELETE 26
So it's not really normal to have a massive write during the day.
Thanks for your help
--
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, zhouqq@cs.toronto.edu
Subject: Re: weird performances problem
In-Reply-To: <4382EB58.3020804@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