Hi Team,
I faced a scenario where after a heavy update query (touching ~100k records) the logical replication was hung.
After enabling debug logging, we found it was spilling to disk and increased logical_decoding_work_mem from 64MB to 4GB. Replication started working after that
I am trying to understand why the replication was just hung ? Also, How do we decide for an optimal configuration of logical_decoding_work_mem.?
Even if it reaches 64MB, it should be able to spill to disk and continue, may be not at the same speed but slowly
Note: There were no subtransactions involved, it was a simple update query touching a lot of records.
Thanks,
Nikhil