Hi all,
I can see that value pg_stat_database.xact_rollback for my db is instantly growing, but I can not find a way to log these rolled back transactions (or, may be, last statement within).
Even with
log_min_duration_statement = 0
log_statement = 'all'
there is no error messages in log.
I mean that I was expecting something like this (for example)
ERROR: value too long for type character varying(4096)
ERROR: current transaction is aborted, commands ignored until end of transaction block
or to see ROLLBACK statement directly.
Can VACUUM be a reason of xact_rollback increasing?
Server version is 9.2.4
P.S,
Root problem is the number of wal files, it raised up significantly (more than 4 times) with the same workload and I do not know why.