Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication gradually slowing down, then hanging. - Mailing list pgsql-general

From Lukasz Biegaj
Subject Re: Logical replication gradually slowing down, then hanging.
Date
Msg-id 127b334c-0675-c078-2958-9e52979b7cdb@unitygroup.com
Whole thread Raw
In response to Logical replication gradually slowing down, then hanging.  (Lukasz Biegaj <lukasz.biegaj@unitygroup.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Paul Förster
Date:
Subject: Re: How to keep format of views source code as entered?
Next
From: Atul Kumar
Date:
Subject: postgres optimization