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  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: autovacuum big table taking hours and sometimes seconds
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Transaction size and Wal2Json