| From: | Lukasz Biegaj <lukasz(dot)biegaj(at)unitygroup(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Logical replication gradually slowing down, then hanging. |
| Date: | 2021-01-14 07:33:13 |
| Message-ID: | 127b334c-0675-c078-2958-9e52979b7cdb@unitygroup.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atul Kumar | 2021-01-14 11:28:32 | postgres optimization |
| Previous Message | Paul Förster | 2021-01-14 06:16:10 | Re: How to keep format of views source code as entered? |