From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephen Frost <sfrost@snowman.net>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Bossart, Nathan <bossartn@amazon.com>
Cc: Michael Paquier <michael@paquier.xyz>
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: Tue, 19 Jan 2021 15:12:34 -0500
Message-ID: <520756.1611087154@sss.pgh.pa.us> (raw)
In-Reply-To: <20210119194748.GP27507@tamriel.snowman.net>
References: <20201210171602.GP16415@tamriel.snowman.net>
<20201210172126.GA25979@alvherre.pgsql>
<20201210172255.GQ16415@tamriel.snowman.net>
<20210113221038.GG27507@tamriel.snowman.net>
<ba8bb5e9-8c43-11b6-eb99-ae794cd37665@enterprisedb.com>
<20210119191450.GO27507@tamriel.snowman.net>
<519044.1611084646@sss.pgh.pa.us>
<20210119194748.GP27507@tamriel.snowman.net>
Stephen Frost <sfrost@snowman.net> writes:
> In passing, I noticed that we have a lot of documentation like:
> This parameter can only be set in the postgresql.conf file or on the
> server command line.
> ... which hasn't been true since the introduction of ALTER SYSTEM.
Well, it's still true if you understand "the postgresql.conf file"
to cover whatever's included by postgresql.conf, notably
postgresql.auto.conf (and the include facility existed long before
that, too, so you needed the expanded interpretation even then).
Still, I take your point that it's confusing.
I like your suggestion of shortening all of these to be "can only be set
at server start", or maybe better "cannot be changed after server start".
I'm not sure whether or not we really need new text elsewhere; I think
section 20.1 is pretty long already.
regards, tom lane
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: tgl@sss.pgh.pa.us, sfrost@snowman.net, peter.eisentraut@enterprisedb.com, alvherre@alvh.no-ip.org, laurenz.albe@cybertec.at, bossartn@amazon.com, michael@paquier.xyz, mailings@oopsware.de, tsunakawa.takay@fujitsu.com
Subject: Re: Change default of checkpoint_completion_target
In-Reply-To: <520756.1611087154@sss.pgh.pa.us>
* 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