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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] Bug #613: Sequence values fall back to previously chec kpointed
Дата
Msg-id 11823.1016058548@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] Bug #613: Sequence values fall back to previously chec kpointed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: insert statements
Следующее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: Re: select max(column) not using index