Re: PostgreSQL 8.0 occasionally slow down - Mailing list pgsql-performance

From Richard Huxton
Subject Re: PostgreSQL 8.0 occasionally slow down
Date
Msg-id 46836B66.7050109@archonet.com
Whole thread Raw
In response to Re: PostgreSQL 8.0 occasionally slow down  ("Ho Fat Tsang" <namiwf@gmail.com>)
Responses Re: PostgreSQL 8.0 occasionally slow down  ("Ho Fat Tsang" <namiwf@gmail.com>)
List pgsql-performance
Ho Fat Tsang wrote:
> Hi Richard,
>
>   I have tuned the checkpoint_timeout to 30 second which is ten times less
> than default and the issue is still reproduced. Do you have any recommended
> configuration for WAL ?

If you look at the output of "vmstat 10" and "iostat -m 10" (I'm
assuming you're on Linux) does it show your I/O peaking every three
minutes? I might have been wrong about the cause.

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: "Ho Fat Tsang"
Date:
Subject: Re: PostgreSQL 8.0 occasionally slow down
Next
From: Chris
Date:
Subject: Re: update query taking too long