Re: should we enable log_checkpoints out of the box? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: should we enable log_checkpoints out of the box?
Date
Msg-id 1014155.1635709437@sss.pgh.pa.us
Whole thread Raw
In response to Re: should we enable log_checkpoints out of the box?  (Andres Freund <andres@anarazel.de>)
Responses Re: should we enable log_checkpoints out of the box?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2021-10-31 10:59:19 -0400, Tom Lane wrote:
>> No DBA would be likely to consider it as anything but log spam.

> I don't agree at all. No postgres instance should be run without
> log_checkpoints enabled. Performance is poor if checkpoints are
> triggered by anything but time, and that can only be diagnosed if
> log_checkpoints is on.

This is complete nonsense.  If we think that's a generic problem, we
should be fixing the problem (ie, making the checkpointer smarter);
not expecting that DBAs will monitor their logs for an undocumented
issue.  The number of installations where that would actually happen
is epsilon compared to the number where it won't.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: inefficient loop in StandbyReleaseLockList()
Next
From: Thomas Munro
Date:
Subject: Re: Time to drop plpython2?