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

From Magnus Hagander
Subject Re: Change default of checkpoint_completion_target
Date
Msg-id CABUevEzYPRtrA1gPtT6d6XhevzK3wpmn-=1AqEq2HoysN1_MUg@mail.gmail.com
Whole thread Raw
In response to Re: Change default of checkpoint_completion_target  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers


On Tue, Dec 8, 2020 at 6:42 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Bossart, Nathan" <bossartn@amazon.com> writes:
> On 12/7/20, 9:53 AM, "Stephen Frost" <sfrost@snowman.net> wrote:
>> Concretely, attached is a patch which changes the default and updates
>> the documentation accordingly.

> +1 to setting checkpoint_completion_target to 0.9 by default.

FWIW, I kind of like the idea of getting rid of it completely.
Is there really ever a good reason to set it to something different
than that?  If not, well, we have too many GUCs already, and each
of them carries nonzero performance, documentation, and maintenance
overhead.

+1.

There are plenty of cases I think where it doesn't really matter with the values, but when it does I'm not sure what it would be where something else would actually be better.

--

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Change default of checkpoint_completion_target
Next
From: Andrey Borodin
Date:
Subject: Re: MultiXact\SLRU buffers configuration