From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Stephen Frost <sfrost@snowman.net>
To: Michael Paquier <michael@paquier.xyz>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Bossart, Nathan <bossartn@amazon.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Bernd Helmle <mailings@oopsware.de>
Cc: tsunakawa.takay@fujitsu.com <tsunakawa.takay@fujitsu.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: Change default of checkpoint_completion_target
Date: Mon, 7 Dec 2020 20:08:25 +0100
Message-ID: <5285eb02-3340-7728-9f62-1a4365eda850@enterprisedb.com> (raw)
In-Reply-To: <20201207175329.GM16415@tamriel.snowman.net>
References: <20201207175329.GM16415@tamriel.snowman.net>
On 2020-12-07 18:53, Stephen Frost wrote:
> * Michael Paquier (michael@paquier.xyz) wrote:
>> On Sun, Dec 06, 2020 at 10:03:08AM -0500, Stephen Frost wrote:
>>> * Alvaro Herrera (alvherre@alvh.no-ip.org) wrote:
>>>> You keep making this statement, and I don't necessarily disagree, but if
>>>> that is the case, please explain why don't we have
>>>> checkpoint_completion_target set to 0.9 by default? Should we change
>>>> that?
>>>
>>> Yes, I do think we should change that..
>>
>> Agreed. FWIW, no idea for others, but it is one of those parameters I
>> keep telling to update after a default installation.
>
> Concretely, attached is a patch which changes the default and updates
> the documentation accordingly.
I agree with considering this change, but I wonder why the value 0.9.
Why not, say, 0.95, 0.99, or 1.0?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: peter.eisentraut@enterprisedb.com, sfrost@snowman.net, michael@paquier.xyz, alvherre@alvh.no-ip.org, bossartn@amazon.com, laurenz.albe@cybertec.at, mailings@oopsware.de, tsunakawa.takay@fujitsu.com
Subject: Re: Change default of checkpoint_completion_target
In-Reply-To: <5285eb02-3340-7728-9f62-1a4365eda850@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox