Re: archive status ".ready" files may be created too early

Поиск
Список
Период
Сортировка
Искать
От
Bossart, Nathan
Тема
Re: archive status ".ready" files may be created too early
Дата
Msg-id
1264128B-5757-4A56-974E-45447FC09433@amazon.com
Ответ на
Список
Дерево обсуждения
archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@2ndquadrant.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Fujii Masao <masao.fujii@gmail.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early Michael Paquier <michael@paquier.xyz>
Re: archive status ".ready" files may be created too early Heikki Linnakangas <hlinnaka@iki.fi>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Andrey Borodin <x4mmm@yandex-team.ru>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Robert Haas <robertmhaas@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Robert Haas <robertmhaas@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Michael Paquier <michael@paquier.xyz>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Fujii Masao <masao.fujii@oss.nttdata.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Robert Haas <robertmhaas@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Robert Haas <robertmhaas@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andrey Borodin <x4mmm@yandex-team.ru>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Attached is a new version of the patch with all feedback addressed.

On 8/16/21, 5:09 PM, "alvherre@alvh.no-ip.org"  wrote:
> The reason for the latter is that I suspect the segment boundary map
> will also have a use to fix the streaming replication issue I mentioned
> earlier in the thread.  This also makes me think that we'll want the wal
> record *start* address to be in the hash table too, not just its *end*
> address.  So we'll use the start-1 as position to send, rather than the
> end-of-segment when GetFlushRecPtr() returns that.

I've been thinking about the next steps for this one, too.  ISTM we'll
need to basically assume that the flush pointer jumps along record
boundaries except for the cross-segment records.  I don't know if that
is the safest assumption, but I think the alternative involves
recording every record boundary in the map.

Nathan

В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Masahiko Sawada
Дата:
FAQ