From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | "Greg Smith" <gsmith(at)gregsmith(dot)com> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL 8.0 occasionally slow down |
Date: | 2007-06-28 14:16:49 |
Message-ID: | 876458b1v2.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
"Greg Smith" <gsmith(at)gregsmith(dot)com> writes:
> On Thu, 28 Jun 2007, Ho Fat Tsang wrote:
>
>> I have tuned the checkpoint_timeout to 30 second which is ten times less than
>> default and the issue is still reproduced.
>
> Your problem looks exactly like a pause at every checkpoint, and I'm not
> sure what Richard was thinking when he suggested having them more often
> would improve things.
Having frequent checkpoints is bad for overall performance but should reduce
the severity of the checkpoint impact. I interpreted his comment as saying he
lowered it just as an experiment to test if it was checkpoint causing the
problems not as a permanent measure.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2007-06-28 14:19:11 | Re: PostgreSQL 8.0 occasionally slow down |
Previous Message | Greg Smith | 2007-06-28 13:52:54 | Re: PostgreSQL 8.0 occasionally slow down |