Re: Replication lag due to lagging restart_lsn

2020-08-19 Thread Kiran Singh
When logical replication is setup, any wal generation on any tables will result in replication lag. Since you are running a long running transaction on the master, the maximum number of changes kept in the memory per transaction is 4MB. If the transaction requires more than 4MB the changes are spil

Re: Replication lag due to lagging restart_lsn

2020-08-19 Thread Kyotaro Horiguchi
Hello. At Tue, 18 Aug 2020 09:27:34 -0700, Satyam Shekhar wrote in > Hello, > > I wish to use logical replication in Postgres to capture transactions as > CDC and forward them to a custom sink. > > To understand the overhead of logical replication workflow I created a toy > subscriber using t