Transaction size and Wal2Json

Поиск
Список
Период
Сортировка
От Mai Peng
Тема Transaction size and Wal2Json
Дата
Msg-id E4B1FAE2-6E72-495C-A470-4224CE063C4D@webedia-group.com
обсуждение исходный текст
Ответы Re: Transaction size and Wal2Json
Список 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 по дате отправления: