From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christoph Berg <myon@debian.org>
Cc: Jonathan S. Katz <jkatz@postgresql.org>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: Joe Conway <mail@joeconway.com>
Cc: Mark Dilger <mark.dilger@enterprisedb.com>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: How about a psql backslash command to show GUCs?
Date: Tue, 07 Jun 2022 19:58:25 -0400
Message-ID: <1436476.1654646305@sss.pgh.pa.us> (raw)
In-Reply-To: <1219250.1654621343@sss.pgh.pa.us>
References: <9439380b-a81f-c910-f527-db4d470b026b@postgresql.org>
<531275.1649707882@sss.pgh.pa.us>
<7bba5a32-65fe-04e1-7c36-efd963a625c9@postgresql.org>
<807242.1649776780@sss.pgh.pa.us>
<20220606135529.GV29853@telsasoft.com>
<918042.1654531335@sss.pgh.pa.us>
<CA+TgmoZQUHhhrw8ZHAaM0jKdpx+5OP7b3pLwNEFDbk5C0VVpuQ@mail.gmail.com>
<952350.1654549308@sss.pgh.pa.us>
<CA+Tgmob12ZKj-S6mnFbBMS7DPuiSHV8H0bd7UP=pXT+BYj8a3Q@mail.gmail.com>
<29d873fa-ce53-0eeb-ddf5-0a0d38458d16@postgresql.org>
<Yp9vMaQFGTkkcqDu@msg.df7cb.de>
<1219250.1654621343@sss.pgh.pa.us>
I wrote:
> The attached draft patch makes the following changes:
Here's a v2 that polishes the loose ends:
> (I didn't do anything about in_hot_standby, which is set through
> a hack rather than via set_config_option; not sure whether we want
> to do anything there, or what it should be if we do.)
I concluded that directly assigning to in_hot_standby was a fairly
horrid idea and we should just change it with SetConfigOption.
With this coding, as long as in_hot_standby is TRUE it will show
as having a non-default setting in \dconfig. I had to remove the
assertion I'd added about PGC_INTERNAL variables only receiving
"default" values, but this just shows that was too inflexible anyway.
> * The rlimit-derived value of max_stack_depth is likewise relabeled
> as PGC_S_DYNAMIC_DEFAULT, resolving the complaint Jonathan had upthread.
> But now that we have a way to hide this, I'm having second thoughts
> about whether we should. If you are on a platform that's forcing an
> unreasonably small stack size, it'd be good if \dconfig told you so.
> Could it be sane to label that value as PGC_S_DYNAMIC_DEFAULT only when
> it's the limit value (2MB) and PGC_S_ENV_VAR when it's smaller?
I concluded that was just fine and did it.
regards, tom lane
Attachments:use-PGC_S_DYNAMIC_DEFAULT-in-more-places-2.patch (text/x-diff, 10.3K) downloaddiff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.cindex 71136b11a2..8764084e21 100644--- a/src/backend/access/transam/xlog.c+++ b/src/backend/access/transam/xlog.c@@ -4167,7 +4167,7 @@ ReadControlFile(void)
snprintf(wal_segsz_str, sizeof(wal_segsz_str), "%d", wal_segment_size);
SetConfigOption("wal_segment_size", wal_segsz_str, PGC_INTERNAL,
- PGC_S_OVERRIDE);+ PGC_S_DYNAMIC_DEFAULT);
/* check and update variables dependent on wal_segment_size */
if (ConvertToXSegs(min_wal_size_mb, wal_segment_size) < 2)
@@ -4186,7 +4186,7 @@ ReadControlFile(void)
/* Make the initdb settings visible as GUC variables, too */
SetConfigOption("data_checksums", DataChecksumsEnabled() ? "yes" : "no",
- PGC_INTERNAL, PGC_S_OVERRIDE);+ PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
}
/*
@@ -4343,13 +4343,22 @@ XLOGShmemSize(void)
* This isn't an amazingly clean place to do this, but we must wait till
* NBuffers has received its final value, and must do it before using the
* value of XLOGbuffers to do anything important.
+ *+ * We prefer to report this value's source as PGC_S_DYNAMIC_DEFAULT.+ * However, if the DBA explicitly set wal_buffers = -1 in the config file,+ * then PGC_S_DYNAMIC_DEFAULT will fail to override that and we must force+ * the matter with PGC_S_OVERRIDE.
*/
if (XLOGbuffers == -1)
{
char buf[32];
snprintf(buf, sizeof(buf), "%d", XLOGChooseNumBuffers());
- SetConfigOption("wal_buffers", buf, PGC_POSTMASTER, PGC_S_OVERRIDE);+ SetConfigOption("wal_buffers", buf, PGC_POSTMASTER,+ PGC_S_DYNAMIC_DEFAULT);+ if (XLOGbuffers == -1) /* failed to apply it? */+ SetConfigOption("wal_buffers", buf, PGC_POSTMASTER,+ PGC_S_OVERRIDE);
}
Assert(XLOGbuffers > 0);
diff --git a/src/backend/bootstrap/bootstrap.c b/src/backend/bootstrap/bootstrap.cindex 9fa8fdd4cf..9a610d41ad 100644--- a/src/backend/bootstrap/bootstrap.c+++ b/src/backend/bootstrap/bootstrap.c@@ -262,7 +262,7 @@ BootstrapModeMain(int argc, char *argv[], bool check_only)
(errcode(ERRCODE_INVALID_PARAMETER_VALUE),
errmsg("-X requires a power of two value between 1 MB and 1 GB")));
SetConfigOption("wal_segment_size", optarg, PGC_INTERNAL,
- PGC_S_OVERRIDE);+ PGC_S_DYNAMIC_DEFAULT);
}
break;
case 'c':
diff --git a/src/backend/postmaster/postmaster.c b/src/backend/postmaster/postmaster.cindex 3b73e26956..dde4bc25b1 100644--- a/src/backend/postmaster/postmaster.c+++ b/src/backend/postmaster/postmaster.c@@ -921,7 +921,7 @@ PostmasterMain(int argc, char *argv[])
* useful to show, even if one would only expect at least PANIC. LOG
* entries are hidden.
*/
- SetConfigOption("log_min_messages", "FATAL", PGC_INTERNAL,+ SetConfigOption("log_min_messages", "FATAL", PGC_SUSET,
PGC_S_OVERRIDE);
}
diff --git a/src/backend/storage/ipc/ipci.c b/src/backend/storage/ipc/ipci.cindex 26372d95b3..1a6f527051 100644--- a/src/backend/storage/ipc/ipci.c+++ b/src/backend/storage/ipc/ipci.c@@ -334,7 +334,8 @@ InitializeShmemGUCs(void)
size_b = CalculateShmemSize(NULL);
size_mb = add_size(size_b, (1024 * 1024) - 1) / (1024 * 1024);
sprintf(buf, "%zu", size_mb);
- SetConfigOption("shared_memory_size", buf, PGC_INTERNAL, PGC_S_OVERRIDE);+ SetConfigOption("shared_memory_size", buf,+ PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
/*
* Calculate the number of huge pages required.
@@ -346,6 +347,7 @@ InitializeShmemGUCs(void)
hp_required = add_size(size_b / hp_size, 1);
sprintf(buf, "%zu", hp_required);
- SetConfigOption("shared_memory_size_in_huge_pages", buf, PGC_INTERNAL, PGC_S_OVERRIDE);+ SetConfigOption("shared_memory_size_in_huge_pages", buf,+ PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
}
}
diff --git a/src/backend/utils/init/miscinit.c b/src/backend/utils/init/miscinit.cindex ec6a61594a..b25bd0e583 100644--- a/src/backend/utils/init/miscinit.c+++ b/src/backend/utils/init/miscinit.c@@ -787,7 +787,7 @@ InitializeSessionUserId(const char *rolename, Oid roleid)
PGC_BACKEND, PGC_S_OVERRIDE);
SetConfigOption("is_superuser",
AuthenticatedUserIsSuperuser ? "on" : "off",
- PGC_INTERNAL, PGC_S_OVERRIDE);+ PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
ReleaseSysCache(roleTup);
}
@@ -844,7 +844,7 @@ SetSessionAuthorization(Oid userid, bool is_superuser)
SetConfigOption("is_superuser",
is_superuser ? "on" : "off",
- PGC_INTERNAL, PGC_S_OVERRIDE);+ PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
}
/*
@@ -901,7 +901,7 @@ SetCurrentRoleId(Oid roleid, bool is_superuser)
SetConfigOption("is_superuser",
is_superuser ? "on" : "off",
- PGC_INTERNAL, PGC_S_OVERRIDE);+ PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
}
diff --git a/src/backend/utils/init/postinit.c b/src/backend/utils/init/postinit.cindex fa701daa26..6b9082604f 100644--- a/src/backend/utils/init/postinit.c+++ b/src/backend/utils/init/postinit.c@@ -391,7 +391,7 @@ CheckMyDatabase(const char *name, bool am_superuser, bool override_allow_connect
SetDatabaseEncoding(dbform->encoding);
/* Record it as a GUC internal option, too */
SetConfigOption("server_encoding", GetDatabaseEncodingName(),
- PGC_INTERNAL, PGC_S_OVERRIDE);+ PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
/* If we have no other source of client_encoding, use server encoding */
SetConfigOption("client_encoding", GetDatabaseEncodingName(),
PGC_BACKEND, PGC_S_DYNAMIC_DEFAULT);
@@ -470,8 +470,8 @@ CheckMyDatabase(const char *name, bool am_superuser, bool override_allow_connect
}
/* Make the locale settings visible as GUC variables, too */
- SetConfigOption("lc_collate", collate, PGC_INTERNAL, PGC_S_OVERRIDE);- SetConfigOption("lc_ctype", ctype, PGC_INTERNAL, PGC_S_OVERRIDE);+ SetConfigOption("lc_collate", collate, PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);+ SetConfigOption("lc_ctype", ctype, PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
check_strxfrm_bug();
diff --git a/src/backend/utils/misc/guc-file.l b/src/backend/utils/misc/guc-file.lindex 4360c461df..ce5633844c 100644--- a/src/backend/utils/misc/guc-file.l+++ b/src/backend/utils/misc/guc-file.l@@ -401,9 +401,8 @@ ProcessConfigFileInternal(GucContext context, bool applySettings, int elevel)
* be run only after initialization is complete.
*
* XXX this is an unmaintainable crock, because we have to know how to set
- * (or at least what to call to set) every variable that could potentially- * have PGC_S_DYNAMIC_DEFAULT or PGC_S_ENV_VAR source. However, there's no- * time to redesign it for 9.1.+ * (or at least what to call to set) every non-PGC_INTERNAL variable that+ * could potentially have PGC_S_DYNAMIC_DEFAULT or PGC_S_ENV_VAR source.
*/
if (context == PGC_SIGHUP && applySettings)
{
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.cindex 55d41ae7d6..a7cc49898b 100644--- a/src/backend/utils/misc/guc.c+++ b/src/backend/utils/misc/guc.c@@ -5939,6 +5939,8 @@ InitializeGUCOptionsFromEnvironment(void)
* rlimit isn't exactly an "environment variable", but it behaves about
* the same. If we can identify the platform stack depth rlimit, increase
* default stack depth setting up to whatever is safe (but at most 2MB).
+ * Report the value's source as PGC_S_DYNAMIC_DEFAULT if it's 2MB, or as+ * PGC_S_ENV_VAR if it's reflecting the rlimit limit.
*/
stack_rlimit = get_stack_depth_rlimit();
if (stack_rlimit > 0)
@@ -5947,12 +5949,19 @@ InitializeGUCOptionsFromEnvironment(void)
if (new_limit > 100)
{
+ GucSource source;
char limbuf[16];
- new_limit = Min(new_limit, 2048);- sprintf(limbuf, "%ld", new_limit);+ if (new_limit < 2048)+ source = PGC_S_ENV_VAR;+ else+ {+ new_limit = 2048;+ source = PGC_S_DYNAMIC_DEFAULT;+ }+ snprintf(limbuf, sizeof(limbuf), "%ld", new_limit);
SetConfigOption("max_stack_depth", limbuf,
- PGC_POSTMASTER, PGC_S_ENV_VAR);+ PGC_POSTMASTER, source);
}
}
}
@@ -6776,12 +6785,16 @@ BeginReportingGUCOptions(void)
reporting_enabled = true;
/*
- * Hack for in_hot_standby: initialize with the value we're about to send.+ * Hack for in_hot_standby: set the GUC value true if appropriate. This+ * is kind of an ugly place to do it, but there's few better options.+ *
* (This could be out of date by the time we actually send it, in which
* case the next ReportChangedGUCOptions call will send a duplicate
* report.)
*/
- in_hot_standby = RecoveryInProgress();+ if (RecoveryInProgress())+ SetConfigOption("in_hot_standby", "true",+ PGC_INTERNAL, PGC_S_OVERRIDE);
/* Transmit initial values of interesting variables */
for (i = 0; i < num_guc_variables; i++)
@@ -6822,15 +6835,8 @@ ReportChangedGUCOptions(void)
* transition from false to true.
*/
if (in_hot_standby && !RecoveryInProgress())
- {- struct config_generic *record;-- record = find_option("in_hot_standby", false, false, ERROR);- Assert(record != NULL);- record->status |= GUC_NEEDS_REPORT;- report_needed = true;- in_hot_standby = false;- }+ SetConfigOption("in_hot_standby", "false",+ PGC_INTERNAL, PGC_S_OVERRIDE);
/* Quick exit if no values have been changed */
if (!report_needed)
diff --git a/src/include/utils/guc.h b/src/include/utils/guc.hindex efcbad7842..d5976ecbfb 100644--- a/src/include/utils/guc.h+++ b/src/include/utils/guc.h@@ -83,8 +83,7 @@ typedef enum
* override the postmaster command line.) Tracking the source allows us
* to process sources in any convenient order without affecting results.
* Sources <= PGC_S_OVERRIDE will set the default used by RESET, as well
- * as the current value. Note that source == PGC_S_OVERRIDE should be- * used when setting a PGC_INTERNAL option.+ * as the current value.
*
* PGC_S_INTERACTIVE isn't actually a source value, but is the
* dividing line between "interactive" and "non-interactive" sources for
@@ -99,6 +98,11 @@ typedef enum
* shouldn't throw hard errors in this case, at most NOTICEs, since the
* objects might exist by the time the setting is used for real.
*
+ * When setting the value of a non-compile-time-constant PGC_INTERNAL option,+ * source == PGC_S_DYNAMIC_DEFAULT should typically be used so that the value+ * will show as "default" in pg_settings. If there is a specific reason not+ * to want that, use source == PGC_S_OVERRIDE.+ *
* NB: see GucSource_Names in guc.c if you change this.
*/
typedef enum
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, myon@debian.org, jkatz@postgresql.org, robertmhaas@gmail.com, pryzby@telsasoft.com, rjuju123@gmail.com, pavel.stehule@gmail.com, david.g.johnston@gmail.com, mail@joeconway.com, mark.dilger@enterprisedb.com, andrew@dunslane.net, dgrowleyml@gmail.com, alvherre@alvh.no-ip.org
Subject: Re: How about a psql backslash command to show GUCs?
In-Reply-To: <1436476.1654646305@sss.pgh.pa.us>
References: <9439380b-a81f-c910-f527-db4d470b026b@postgresql.org> <531275.1649707882@sss.pgh.pa.us> <7bba5a32-65fe-04e1-7c36-efd963a625c9@postgresql.org> <807242.1649776780@sss.pgh.pa.us> <20220606135529.GV29853@telsasoft.com> <918042.1654531335@sss.pgh.pa.us> <CA+TgmoZQUHhhrw8ZHAaM0jKdpx+5OP7b3pLwNEFDbk5C0VVpuQ@mail.gmail.com> <952350.1654549308@sss.pgh.pa.us> <CA+Tgmob12ZKj-S6mnFbBMS7DPuiSHV8H0bd7UP=pXT+BYj8a3Q@mail.gmail.com> <29d873fa-ce53-0eeb-ddf5-0a0d38458d16@postgresql.org> <Yp9vMaQFGTkkcqDu@msg.df7cb.de> <1219250.1654621343@sss.pgh.pa.us> <1436476.1654646305@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