[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] hanging for 30sec when checkpointing
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2004-02-06 17:34:47
Message-ID: 1529.1076088887 () sss ! pgh ! pa ! us
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]