Re: Incorrect snapshots while promoting hot standby node when 2PC is used

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Incorrect snapshots while promoting hot standby node when 2PC is used
Дата
Msg-id YLTYfUE7VEZvtqeD@paquier.xyz
обсуждение исходный текст
Ответ на Re: Incorrect snapshots while promoting hot standby node when 2PC is used  (Andres Freund <andres@anarazel.de>)
Ответы Re: Incorrect snapshots while promoting hot standby node when 2PC is used  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Thu, May 27, 2021 at 10:01:49AM -0700, Andres Freund wrote:
> Why would it be intrusive? We're talking a split second here, no? More
> importantly, I don't think it's correct to release the locks at that
> point.

I have been looking at all that for the last couple of days, and
checked the code to make sure that relying on RecoveryInProgress() as
the tipping point is logically correct in terms of virtual XID,
snapshot build and KnownAssignedXids cleanup.  This stuff is tricky
enough that I may have missed something, but my impression (and
testing) is that we should be safe.

I am adding this patch to the next CF for now.  More eyes are needed.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: postgres_fdw: Handle boolean comparison predicates
Следующее
От: Alexander Pyhalov
Дата:
Сообщение: join pushdown and issue with foreign update