Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 28 Jun 2007 09:03:50 +0100
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
- Follow-Ups:
- Re: PostgreSQL 8.0 occasionally slow down
- From: Ho Fat Tsang
- Re: PostgreSQL 8.0 occasionally slow down
- References:
- PostgreSQL 8.0 occasionally slow down
- From: Ho Fat Tsang
- Re: PostgreSQL 8.0 occasionally slow down
- From: Richard Huxton
- Re: PostgreSQL 8.0 occasionally slow down
- From: Ho Fat Tsang
- PostgreSQL 8.0 occasionally slow down
- Prev by Date: Re: PostgreSQL 8.0 occasionally slow down
- Next by Date: Re: update query taking too long
- Previous by thread: Re: PostgreSQL 8.0 occasionally slow down
- Next by thread: Re: PostgreSQL 8.0 occasionally slow down
- Indexes: