Re: [BUGS] Bug #613: Sequence values fall back to previously chec kpointed - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [BUGS] Bug #613: Sequence values fall back to previously chec kpointed
Date
Msg-id 11823.1016058548@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] Bug #613: Sequence values fall back to previously chec kpointed  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: insert statements
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: select max(column) not using index