Re: hanging for 30sec when checkpointing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shane Wright <me(at)shanewright(dot)co(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: hanging for 30sec when checkpointing
Date: 2004-02-06 17:34:47
Message-ID: 1529.1076088887@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Shane Wright <me(at)shanewright(dot)co(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message kaolin fire 2004-02-06 17:38:27 FATAL 2: (pg_clog ... no such file or directory)
Previous Message Shane Wright 2004-02-06 17:12:14 Re: hanging for 30sec when checkpointing