Re: Logical replication gradually slowing down, then hanging.

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