From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Bossart, Nathan" <bossartn@amazon.com>
cc: Stephen Frost <sfrost@snowman.net>,
        Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
        Michael Paquier <michael@paquier.xyz>,
        Alvaro Herrera <alvherre@alvh.no-ip.org>,
        Laurenz Albe <laurenz.albe@cybertec.at>,
        "Bernd
 Helmle" <mailings@oopsware.de>,
        "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>,
        "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: Change default of checkpoint_completion_target
In-reply-to: <7CFCC359-5786-40DB-90A8-BDB0F08F2ABC@amazon.com>
References: <20201207175329.GM16415@tamriel.snowman.net>
 <5285eb02-3340-7728-9f62-1a4365eda850@enterprisedb.com>
 <20201207191742.GN16415@tamriel.snowman.net>
 <7CFCC359-5786-40DB-90A8-BDB0F08F2ABC@amazon.com>
Comments: In-reply-to "Bossart, Nathan" <bossartn@amazon.com>
	message dated "Tue, 08 Dec 2020 17:29:30 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3258482.1607449295.1@sss.pgh.pa.us>
Date: Tue, 08 Dec 2020 12:41:35 -0500
Message-ID: <3258483.1607449295@sss.pgh.pa.us>
Precedence: bulk

"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