From: | "Louis-Marie Croisez" <louis-marie(dot)croisez(at)etca(dot)alcatel(dot)be> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: access time performance problem |
Date: | 2002-10-10 11:40:43 |
Message-ID: | 03ef01c27051$ddd28b20$3970cb8a@telchoi.alcatel.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Richard,
I have test it right now mounting the ext3 partition with ext2.
The result is identical.
LM Croisez
----- Original Message -----
From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Louis-Marie Croisez" <louis-marie(dot)croisez(at)etca(dot)alcatel(dot)be>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, October 10, 2002 11:26 AM
Subject: Re: [GENERAL] access time performance problem
On Thursday 10 Oct 2002 9:51 am, Louis-Marie Croisez wrote:
> Sorry, bad url:
> use this instead:
> http://louis.croisez.free.fr/capture1.jpg
>
>
> > Thanx for your response Scott.
> > In order to illustrate my problem, here is a capture of an Excel graph
> > showing the access peaks I get:
> > http://louis.croisez.free.fr/download/capture1.jpg
> > The test program makes updates of a table (on 1000 records randomly)
> > every 50ms. Approximately, every about 3 seconds, the update process is
> > hanged for about 800ms (these data are measured on the Compaq. On the
> > IBM, the results are worse).
> > This is a great problem for us.
> > Could you give me some help to correct that ?
I'm no expert on fs issues, but I do remember reading about bursts of write
activity occuring with ext3 (which you mentioned using in a previous mail,
and Scott remarked upon). IIRC it was something to do with ext3 buffering for
a period and then performing a bunch of writes at the same time. This looks
like a plausible candidate for your problem. The bad news is you'll have to
do some googling, since I can't remember where I heard about it. The good
news is that I seem to remember tuning that would help.
You might find vmstat/iostat useful to identify where the slowdown is
occuring.
- Richard Huxton
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | pascal bérest | 2002-10-10 11:52:36 | pg_restore error |
Previous Message | Savita | 2002-10-10 11:38:39 | Re: Problem running postgre as a windows NT service |