Checkpoints - what happens actually?

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To: pgsql-admin(at)postgresql(dot)org
Subject: Checkpoints - what happens actually?
Date: 2005-06-27 13:21:30
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB167A2@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

i went across a checkpoint problematic (90% load, near real time app). I've
read in pg-documentation what exists about CHECKPOINT and the configuration
parameters. But there're still many open questions as:

What actually happens if a checkpoint occours?
OK, all dirty pages of data files get written to disk...but

Are read requests (simple selects) still possible and quickly answered?

What happens to wite-operations? Do they get queued or can they be written
to xlog while the fsync is running?
Is it maybe really the case but wave of pending statements arises from the
reduced i/o capacity which is left due to the fsync?

How about increasing the interval more and more? Will this produce more and
more dirty pages or is it just that a possible restart will take a longer
time since the xlog is longer?

Questions over questions. Can you please give me a clearing little insight.

Browse pgsql-admin by date

  From Date Subject
Next Message hellz waren 2005-06-27 13:30:43 Re: real time replication of pgsql database
Previous Message Bruce Momjian 2005-06-27 09:45:43 Re: DRDB?