Re: Logical replication gradually slowing down, then hanging.

Поиск
Список
Период
Сортировка
От Lukasz Biegaj
Тема Re: Logical replication gradually slowing down, then hanging.
Дата
Msg-id 127b334c-0675-c078-2958-9e52979b7cdb@unitygroup.com
обсуждение исходный текст
Ответ на Logical replication gradually slowing down, then hanging.  (Lukasz Biegaj <lukasz.biegaj@unitygroup.com>)
Список pgsql-general
On 16.11.2020 10:20, Lukasz Biegaj wrote:
> Hello,
>
> I'm encountering a repeating problem with logical replication.
>
> [...]
>
> And also a gdb backtrace:
> (gdb) bt
> #0  0x00005623348d3ce0 in hash_seq_search ()
> #1  0x000056233473a396 in ReorderBufferQueueChange ()
> #2  0x000056233472fb80 in LogicalDecodingProcessRecord ()
> [...]


Replying to myself for anyone searching for the issue in future:

I believe that the issue was fixed with patch described in thread 

<https://www.postgresql-archive.org/Logical-replication-CPU-bound-with-TRUNCATE-DROP-CREATE-many-tables-tt6155123.html#none>

on pgsql-hackers.


-- 
Lukasz Biegaj | Unity Group | https://www.unitygroup.com/
System Architect, AWS Solutions Architect




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

Предыдущее
От: Paul Förster
Дата:
Сообщение: Re: How to keep format of views source code as entered?
Следующее
От: Atul Kumar
Дата:
Сообщение: postgres optimization