Re: prevent immature WAL streaming
От
Bossart, Nathan
Тема
Re: prevent immature WAL streaming
Дата
Msg-id
68B0D14A-0304-448A-884E-51D0CD286816@amazon.com
Ответ на
Re: prevent immature WAL streaming (Kyotaro Horiguchi)
Список
Дерево обсуждения
prevent immature WAL streaming Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: prevent immature WAL streaming Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: prevent immature WAL streaming "Bossart, Nathan" <bossartn@amazon.com>
Re: prevent immature WAL streaming "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: prevent immature WAL streaming "Bossart, Nathan" <bossartn@amazon.com>
Re: prevent immature WAL streaming "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
RE: prevent immature WAL streaming Jakub Wartak <Jakub.Wartak@tomtom.com>
Re: prevent immature WAL streaming "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: prevent immature WAL streaming "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: prevent immature WAL streaming Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: prevent immature WAL streaming Robert Haas <robertmhaas@gmail.com>
Re: prevent immature WAL streaming Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: prevent immature WAL streaming "Bossart, Nathan" <bossartn@amazon.com>
Re: prevent immature WAL streaming Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: prevent immature WAL streaming "Bossart, Nathan" <bossartn@amazon.com>
Re: prevent immature WAL streaming Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: prevent immature WAL streaming Andres Freund <andres@anarazel.de>
Re: prevent immature WAL streaming Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: prevent immature WAL streaming Andres Freund <andres@anarazel.de>
Re: prevent immature WAL streaming Fujii Masao <masao.fujii@oss.nttdata.com>
Re: prevent immature WAL streaming Andres Freund <andres@anarazel.de>
Re: prevent immature WAL streaming Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: prevent immature WAL streaming Fujii Masao <masao.fujii@oss.nttdata.com>
Re: prevent immature WAL streaming Andres Freund <andres@anarazel.de>
Re: prevent immature WAL streaming "Bossart, Nathan" <bossartn@amazon.com>
Re: prevent immature WAL streaming Kyotaro Horiguchi <horikyota.ntt@gmail.com>
On 8/23/21, 3:53 PM, "Alvaro Herrera" wrote: > As mentioned in the course of thread [1], we're missing a fix for > streaming replication to avoid sending records that the primary hasn't > fully flushed yet. This patch is a first attempt at fixing that problem > by retreating the LSN reported as FlushPtr whenever a segment is > registered, based on the understanding that if no registration exists > then the LogwrtResult.Flush pointer can be taken at face value; but if a > registration exists, then we have to stream only till the start LSN of > that registered entry. I wonder if we need to move the call to RegisterSegmentBoundary() to somewhere before WALInsertLockRelease() for this to work as intended. Right now, boundary registration could take place after the flush pointer has been advanced, which means GetSafeFlushRecPtr() could still return an unsafe position. Nathan
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата: