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
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