pgsql: Reduce log verbosity during prepared transaction recovery

Поиск
Список
Период
Сортировка
Искать

pgsql: Reduce log verbosity during prepared transaction recovery

От:
Fujii Masao <fujii@postgresql.org>
Дата:
Reduce log verbosity during prepared transaction recovery

Previously, RecoverPreparedTransactions() logged each prepared
transaction at LOG level at the end of recovery. With many unresolved
prepared transactions, these messages could clutter the server log.

Lower the severity of these messages to DEBUG2, matching the messages
in PrepareRedoAdd() and PrepareRedoRemoveFull(), and report the
number of successfully recovered prepared transactions in a single
LOG message. This reduces log clutter while retaining per-transaction
details at DEBUG2.

Author: Ashutosh Sharma 
Reviewed-by: Jakub Wartak 
Reviewed-by: Pierre Forstmann 
Reviewed-by: Chao Li 
Reviewed-by: Fujii Masao 
Discussion: https://postgr.es/m/CAE9k0Pmq1qQEvTKqsBTwUAWrNw+191zcTBPVKmmP5E3X2C+_Xw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c11eb5de01ba3401e880195888fb25703e0edf10

Modified Files
--------------
src/backend/access/transam/twophase.c | 16 ++++++++++++----
src/test/recovery/t/009_twophase.pl   | 15 +++++++++++++--
2 files changed, 25 insertions(+), 6 deletions(-)

FAQ