Re: change logging defaults

2021-06-15 Thread Tom Lane
Justin Pryzby writes: > I propose to change some defaults: > log_autovacuum_min_duration = 0 > log_checkpoints = on > log_lock_waits = on (and log_recovery_conflict_waits too?) > log_temp_files = 128kB Why? Based on reports that I see, some quite large percentage of Postgres DBAs never look at t

change logging defaults

2021-06-15 Thread Justin Pryzby
I propose to change some defaults: log_autovacuum_min_duration = 0 log_checkpoints = on log_lock_waits = on (and log_recovery_conflict_waits too?) log_temp_files = 128kB Note that pg_regress does this: | fputs("\n# Configuration added by pg_regress\n\n", pg_conf); | fputs("log_autovacuum_min_dura