Transaction size and Wal2Json - Mailing list pgsql-performance

From Mai Peng
Subject Transaction size and Wal2Json
Date
Msg-id E4B1FAE2-6E72-495C-A470-4224CE063C4D@webedia-group.com
Whole thread Raw
Responses Re: Transaction size and Wal2Json
List pgsql-performance
Hello,

We use the plugin Wal2Json in order to catch every modification on database. We’ve got an issue : WAL were growing very
fast,the state of pg_stat_replication still on ‘catchup’ , an error:pg_recvlogical: unexpected termination of
replicationstream: ERROR: out of memory DETAIL: Cannot enlarge string buffer. It seems Wal2Json can not handle very big
transactions( more than 1 Gb). 
How could we measure the size of a transaction ?
Could we increase this limitation ?
Thank you
Mai

pgsql-performance by date:

Previous
From: David Rowley
Date:
Subject: Re: autovacuum big table taking hours and sometimes seconds
Next
From: Peter Eisentraut
Date:
Subject: Re: Transaction size and Wal2Json