Checkpoint question - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Checkpoint question
Date
Msg-id Pine.LNX.4.58.0601111812270.2317@eon.cs
Whole thread Raw
Responses Re: Checkpoint question  (Simon Riggs <simon@2ndquadrant.com>)
Re: Checkpoint question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I understand checkpoint code doing something like this:
Get RedoRecPtr;Flush all dirty buffers no matter what's its LSN;Write down checkpoint xlog record;

So I wonder is it possible flush only dirty buffers with LSN < RedoRecPtr
to improve checkpoint caused delay? Because even we flush every dirty
buffers, we still have to replay from the RedoRecPtr. Of course, this only
applies to non-critical checkpoints (critical ones like startup and
shutdown).

Regards,
Qingqing



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: sort operation leads planner to different number of rows?
Next
From: Simon Riggs
Date:
Subject: Re: Checkpoint question