Horton

Re: Bug #613: Sequence values fall back to previously chec kpointed

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, bgrimm@zaeon.com, pgsql-bugs@postgresql.org, pgsql-hackers@postgresql.org
Date: 2002-03-13T22:29:08Z
Lists: pgsql-bugs, pgsql-hackers 
I said:
> Mmm ... maybe.  Is this safe if a checkpoint is currently in progress?
> Seems like you could look at RedoRecPtr and decide you are okay, but you
> really are not if checkpointer has already dumped sequence' disk
> buffer and will later set RedoRecPtr to a value beyond the old LSN.

Oh, wait, I take that back: the checkpointer advances RedoRecPtr
*before* it starts to dump disk buffers.

I'm still worried about whether we shouldn't try to simplify, rather
than add complexity.

			regards, tom lane