Re: hanging for 30sec when checkpointing

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: hanging for 30sec when checkpointing
Date: 2004-02-06 19:25:02
Message-ID: 20040206192502.GB22668@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Feb 06, 2004 at 12:34:47PM -0500, Tom Lane wrote:
> Mmm, right, I forgot to mention that one, which was a bit silly
> considering that that was the focus of the discussion. No, infrequent
> checkpoints won't hurt performance between checkpoints.

In my experience, though, they do hurt _quite substantially_ during
the checkpoint. If you need fast all the time, cranking that
interval too high will definitely hurt you.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greenspun

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2004-02-06 20:40:48 Re: Recycled Log Files
Previous Message Naomi Walker 2004-02-06 18:34:18 Recycled Log Files