Re: BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG

Поиск
Список
Период
Сортировка
От shveta malik
Тема Re: BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG
Дата
Msg-id CAJpy0uAjveViJ_zG7uZndZPRc04MkGOSL0js+w8JYvJ4xwLLMw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Yes using XLOG_XACT_INVALIDATIONS. It reduced the number of invalidations
executed per commandId.
I used pstack. But it was pretty quick, not much chance to see stacks.
No lag seen
on the next insert on subscriber after drop publication, even with
heavier testcase.

thanks
Shveta


On Wed, Dec 21, 2022 at 10:45 AM Bowen Shi <zxwsbg12138@gmail.com> wrote:
>
> Hello,
> Thanks for your tests.
>
> >
> > No noticeable lag observed on HEAD with the new mechanism of invalidation.
> >
>
> Does the new mechanism of invalidation mean using
> 'XLOG_XACT_INVALIDATIONS‘ to invalid cache? And did you use perf or
> pstack to watch the walsender process.
>
> thanks
> BowenShi



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

Предыдущее
От: Bowen Shi
Дата:
Сообщение: Re: BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17727: A query crashes server process: ... was terminated by signal 7: Bus error / Segmentation Fault