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

From Tom Lane
Subject Re: hanging for 30sec when checkpointing
Date
Msg-id 1529.1076088887@sss.pgh.pa.us
Whole thread Raw
In response to Re: hanging for 30sec when checkpointing  (Shane Wright <me@shanewright.co.uk>)
Responses Re: hanging for 30sec when checkpointing  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-admin
Shane Wright <me@shanewright.co.uk> writes:
> Although, is there any performance implication of not doing checkpoints
> very often?  (aside from, I assume, that each checkpoint will take
> longer and hence saturate available I/O for longer)

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.

            regards, tom lane

pgsql-admin by date:

Previous
From: kaolin fire
Date:
Subject: FATAL 2: (pg_clog ... no such file or directory)
Next
From: Naomi Walker
Date:
Subject: Recycled Log Files