Re: Change default of checkpoint_completion_target - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Change default of checkpoint_completion_target
Date
Msg-id 20201210171602.GP16415@tamriel.snowman.net
Whole thread Raw
In response to Re: Change default of checkpoint_completion_target  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Change default of checkpoint_completion_target
Re: Change default of checkpoint_completion_target
List pgsql-hackers
Greetings,

* Laurenz Albe (laurenz.albe@cybertec.at) wrote:
> On Tue, 2020-12-08 at 17:29 +0000, Bossart, Nathan wrote:
> > +1 to setting checkpoint_completion_target to 0.9 by default.
>
> +1 for changing the default or getting rid of it, as Tom suggested.

Attached is a patch to change it from a GUC to a compile-time #define
which is set to 0.9, with accompanying documentation updates.

> While we are at it, could we change the default of "log_lock_waits" to "on"?

While I agree that it'd be good to change quite a few of the log_X items
to be 'on' by default, I'm not planning to work on this.

Thanks,

Stephen

Attachment

pgsql-hackers by date:

Previous
From: Konstantin Knizhnik
Date:
Subject: Re: Hybrid Hash/Nested Loop joins and caching results from subplans
Next
From: Alvaro Herrera
Date:
Subject: Re: Change default of checkpoint_completion_target