Re: PostgreSQL 8.0 occasionally slow down

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ho Fat Tsang <namiwf(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.0 occasionally slow down
Date: 2007-06-28 08:03:50
Message-ID: 46836B66.7050109@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ho Fat Tsang 2007-06-28 08:17:28 Re: PostgreSQL 8.0 occasionally slow down
Previous Message Ho Fat Tsang 2007-06-28 08:01:30 Re: PostgreSQL 8.0 occasionally slow down