Re: change logging defaults - Mailing list pgsql-hackers

From Tom Lane
Subject Re: change logging defaults
Date
Msg-id 427251.1623776605@sss.pgh.pa.us
Whole thread Raw
In response to change logging defaults  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> 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 the postmaster log at all.  So making the log
bulkier isn't something that will be useful to them.  People who do
want these reports are certainly capable of turning them on.

> Note that pg_regress does this:

What we find useful for testing seems to me to be nearly
unrelated to production needs.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: a path towards replacing GEQO with something better
Next
From: Robert Haas
Date:
Subject: disfavoring unparameterized nested loops