Support large transactions for Postgres

[cilesizemre]

We are having some problems with our Postgres integrations with a transaction that generates more than 1 GB on our replication_slot. In these kinds of problems, we are needed to stop the integration and restart it again.

As I can understand this is because of the limitations on Postgres implementation, if there is a transaction that generates more than 1 GB of data wal2json plugin couldn't handle this. Because of this issue, there are some configuration parameters on the wal2json side like format-version and write-in-chunks

• pg_recvlogical very unstable eulerto/wal2json#100 (comment)
• When i use Debezium and wal2json it cause a problem eulerto/wal2json#183 (comment)

It seems using format-version=2 and write-in-chunks=true look promising.

Is there a way to use these parameters for wal2json or any other way to handle large transactions for Postgres implementation?