Skip site navigation (1) Skip section navigation (2)

Re: Extra XLOG in Checkpoint for StandbySnapshot

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Extra XLOG in Checkpoint for StandbySnapshot
Date: 2013-01-07 13:44:41
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
On 7 January 2013 13:33, Amit Kapila <amit(dot)kapila(at)huawei(dot)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

If you make the correct test, I'd be more inclined to accept the premise.

 Simon Riggs         
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

pgsql-hackers by date

Next:From: Andres FreundDate: 2013-01-07 13:44:47
Subject: Re: Extra XLOG in Checkpoint for StandbySnapshot
Previous:From: Stephen FrostDate: 2013-01-07 13:42:32
Subject: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group