Re: hanging for 30sec when checkpointing - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: hanging for 30sec when checkpointing
Date
Msg-id 20040206192502.GB22668@phlogiston.dyndns.org
Whole thread Raw
In response to Re: hanging for 30sec when checkpointing  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
        --Philip Greenspun

pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Recycled Log Files
Next
From: Andrew Sullivan
Date:
Subject: Re: Recycled Log Files