On 7 January 2013 13:33, Amit Kapila <amit.kapila@huawei.com> wrote:
>> If we skip the WAL record in the way you suggest, we'd be unable to
>> start quickly in some cases.
>
> If there are any operations happened which have generated WAL, then on next
> checkpoint interval the checkpoint operation should happen.
> Which cases will it not able to start quickly?
The case where we do lots of work but momentarily we weren't doing
anything when we took the snapshot.
The absence of write transactions at one specific moment gives no
indication of behaviour at other points across the whole checkpoint
period.
If you make the correct test, I'd be more inclined to accept the premise.
-- Simon Riggs http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services