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

From Tom Lane
Subject Re: Change default of checkpoint_completion_target
Date
Msg-id 3258483.1607449295@sss.pgh.pa.us
Whole thread Raw
In response to Re: Change default of checkpoint_completion_target  ("Bossart, Nathan" <bossartn@amazon.com>)
Responses Re: Change default of checkpoint_completion_target
Re: Change default of checkpoint_completion_target
List pgsql-hackers
"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.

            regards, tom lane



pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: Change default of checkpoint_completion_target
Next
From: Magnus Hagander
Date:
Subject: Re: Change default of checkpoint_completion_target