Optimize walsender handling invalid messages of 'drop publication'

Поиск
Список
Период
Сортировка
От Bowen Shi
Тема Optimize walsender handling invalid messages of 'drop publication'
Дата
Msg-id CAM_vCudj3_HdJ2G5erwq_Jj+-bwfr67yxmS8oh=-cjPXY4pihg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Optimize walsender handling invalid messages of 'drop publication'  (Bowen Shi <zxwsbg12138@gmail.com>)
Список pgsql-hackers
Hi all,

Before PG 14, walsender process has to handle invalid message in one
XLOG (PG 14 provide a particular XLOG type: XLOG_XACT_INVALIDATIONS).
This may bring some problems which has been discussed in previous
mail:
https://www.postgresql.org/message-id/flat/CAM_vCufO3eeRZ_O04z9reiE%2BB644%2BRgczbAVo9C5%2BoHV9S7%2B-g%40mail.gmail.com#981e65567784e0aefa4474cc3fd840f6

This patch can solve the problem. It has three parts:
1. pgoutput do not do useless invalid cache anymore;
2. Add a relid->relfilenode hash map to invoid hash seq search;
3. test case: It needs two or three minutes to finish.

The patch is based on the HEAD of branch REL_13_STABLE. It also works
for PG 10~12.

Thanks.
Bowenshi

Вложения

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Time delayed LR (WAS Re: logical replication restrictions)