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

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