Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x53HE-007aaI-0J for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Sep 2026 15:34:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x53HC-00Ffj3-2R for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Sep 2026 15:34:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x53HC-00Ffiv-1K for pgsql-hackers@lists.postgresql.org; Fri, 11 Sep 2026 15:34:54 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x53H9-00000004AnY-3dR7 for pgsql-hackers@postgresql.org; Fri, 11 Sep 2026 15:34:54 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-5b5e907853eso1088028e87.2 for ; Fri, 11 Sep 2026 08:34:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1789140891; x=1789745691; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :content-type:mime-version:references:message-id:subject:cc:to:from :date:from:to:cc:subject:date:message-id:reply-to:content-type; bh=K49UH3xsTtnRW1XXXLhPyaz9KDWJI/cKXibqouKoDk8=; b=pCjzCyZtoOC/ovHgeyAsfZPmOveg4i+Vdd5Pnl+Cc44YVV1HBbcVCT+HaFF9zr6hto fdPR7Fi8OC21EgxZeurXhcHxZSmjBr3qRUzBLsf92z2panwDKKtfg1K75c9Zpb8Xhn4t ssxqE5x/h934+JQ2/GKSO763KNFT6NDQJ33DePGzRAkRcEC+0A8m8cUoBS6fRo/O67R3 T7sz/A64MhQBEVB6dUS7WJQdQP5pNvSPZil/hPB0Jd3rrFuVX13AQzYR1YmM4NEVn0x0 G1ftUwsSAE3wTkt40+F2pbSjyT+ln9tV9Xqd8TTdJ73cQI64LXn8hDRlZeIg9gZM6vG8 yjbw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1789140891; x=1789745691; h=in-reply-to:content-transfer-encoding:content-disposition :content-type:mime-version:references:message-id:subject:cc:to:from :date:x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to:content-type; bh=K49UH3xsTtnRW1XXXLhPyaz9KDWJI/cKXibqouKoDk8=; b=aDxCMf0ahaDJPvAP5aSowvEZP9A2vKea7AMh5/NT41+uKfjFjZE7ICyLXgbN59RmUy 3X7leh0H/2r6yQdZZk4cWVf/vGheb548TFOx7758zpbHu5r8IsB3IT3/5ffH2MXxKCuT qTVKmyc+BsuC8eLXhklgfiaVncKt1NGYafo0rQUXGja55TtDVVidJuKWXC4oLF49wBTQ kbkKuaokBsxH11x+IPXqNz5DImGZae8hKtnZlKY+2LHPBzTkBlCOTExiGasNkciQeome VK1OAuQI+lL/wIrXDyu2DZw7eeMXvkl4wNjDt3Rj5BbHrqxH2nC1FDP8qpju/K0KNsO2 2xNQ== X-Forwarded-Encrypted: i=1; AKwUvBzEIH0owLOJxDiQvd0pR2p1RV0ahO4FWcO568XU5RBPs/wtpRx04KHvuywgHkqGePOMV4gXSfLOuYn6ZWuQ@postgresql.org X-Gm-Message-State: AFuF++lxlNIrdhaDNeEkWhgtVkVPDJy796pm+RDPwSm+nXDR2+EgVa1q Ivkv9HW190/tH602DUyCIyTEXKUBJEc30G8TSGk9FHaw5Ux4lvPen/xH X-Gm-Gg: AYBFou22FO8yCyvTDrj+NTGQkzc002fnXKfKFcFzPgDUyWwxajjs5pb/23DbqeHaNsK K1UiwPTGkmOaVR5xftiMP8mzd+67tu5azXbH1kjowT8h7jk9Qg9f6DGYCMy467PBie6VRdzzDAt IWyMpLoh1JX69QzNulkYeclzTJjtORjSUabDUeTfvOOtXfalrpLyYNPg0ZAOdUJfFgqtavijOVp fr4emjKYbXTgOAkQjYdV/Ynm4kTRZvCfWM4e4UneU4/6uaS5doCWdQPVg236IT9kwYdTGyxpncT YyHkz98UejxXnJjg3l+Rq3AVuYUHlxku1oubzimLm3ydHz2R7xGa2418rgb2caUQu4aHBW/Qt28 MzDB/u630CnxXid2LOVCg65hW6PmuYOSLMbVS12fJ38AKlCixV4LtqJF8SLkyHJuCGTrWBRZpC1 2eKhrtemaTXKa3VBG96PNpRqswq1nQtfYS5SjzZuGW0/kXlnGj7ixV99bcc4g0ulUbCBar6gJwS MdiPXVotUopNKTQ2ZuuHXdtehRlVf5qFt/2BR7M8RyMKcxzTbpPXWB0c/l/DFMAc+47Tp6YrXPO VxlMrCPQzSoIlUQ0qpwSVpeqEA== X-Received: by 2002:ac2:4c52:0:b0:5b8:998c:e94 with SMTP id 2adb3069b0e04-5b8a030ee0bmr1218043e87.46.1789140890302; Fri, 11 Sep 2026 08:34:50 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 38308e7fff4ca-3a5a3144a4esm7669091fa.0.2026.09.11.08.34.47 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 11 Sep 2026 08:34:49 -0700 (PDT) Date: Fri, 11 Sep 2026 10:34:45 -0500 From: Nathan Bossart To: =?utf-8?Q?=C3=81lvaro?= Herrera Cc: Chao Li , Fujii Masao , Bharath Rupireddy , pgsql-hackers@postgresql.org Subject: Re: fixes for a few GUC descriptions Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="OzAxZwZk1264o+ni" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --OzAxZwZk1264o+ni Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit On Fri, Sep 11, 2026 at 11:14:03AM +0200, Álvaro Herrera wrote: > Maybe it should say "0 means do not wait, -1 means wait indefinitely." > This complements the short_desc, > > Sets the maximum time the server waits during shutdown for all WAL data > to be replicated to the receiver. > > I think the words "for the receiver to catch up" is somehow at odds with > the short_desc's "for all WAL data to be replicated". They should be > saying the same thing, but aren't. WFM. v2 uses that wording, except -1 is listed first so that the special values stay in ascending order. I was considering back-patching this to v19. I'd rather not update the descriptions in released versions, although I'm not even sure anything in released versions need fixing. Any concerns about this? -- nathan --OzAxZwZk1264o+ni Content-Type: text/plain; charset=utf-8 Content-Disposition: attachment; filename=v2-0001-Describe-special-values-in-more-GUC-descriptions.patch Content-Transfer-Encoding: 8bit From 2ea9715a91a3101641e2ff8e8271eb2a6236efb4 Mon Sep 17 00:00:00 2001 From: Nathan Bossart Date: Fri, 11 Sep 2026 10:27:16 -0500 Subject: [PATCH v2 1/1] Describe special values in more GUC descriptions. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Commit 977d865c36 established some rules for mentioning special values (e.g., -1, 0, an empty string) in GUC descriptions. A few parameters either neglect to mention their special values or describe them in a way that doesn't follow those rules. Most of these parameters were added after the aforementioned commit. This commit fixes them. Reviewed-by: Bharath Rupireddy Reviewed-by: Fujii Masao Reviewed-by: Chao Li Reviewed-by: Álvaro Herrera Discussion: https://postgr.es/m/aqMkIpRr62cVqtCZ%40nathan --- src/backend/utils/misc/guc_parameters.dat | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/src/backend/utils/misc/guc_parameters.dat b/src/backend/utils/misc/guc_parameters.dat index 93a434858bf..c57441f7d98 100644 --- a/src/backend/utils/misc/guc_parameters.dat +++ b/src/backend/utils/misc/guc_parameters.dat @@ -1303,6 +1303,7 @@ { name => 'idle_replication_slot_timeout', type => 'int', context => 'PGC_SIGHUP', group => 'REPLICATION_SENDING', short_desc => 'Sets the duration a replication slot can remain idle before it is invalidated.', + long_desc => '0 disables the timeout.', flags => 'GUC_UNIT_S', variable => 'idle_replication_slot_timeout_secs', boot_val => '0', @@ -1389,6 +1390,7 @@ { name => 'io_max_concurrency', type => 'int', context => 'PGC_POSTMASTER', group => 'RESOURCES_IO', short_desc => 'Max number of IOs that one process can execute simultaneously.', + long_desc => '-1 means use a value based on "shared_buffers" and the maximum number of processes.', variable => 'io_max_concurrency', boot_val => '-1', min => '-1', @@ -1876,7 +1878,7 @@ { name => 'log_statement_max_length', type => 'int', context => 'PGC_SUSET', group => 'LOGGING_WHAT', short_desc => 'Sets the maximum length in bytes of logged statement text.', - long_desc => '-1 means log statement in full; 0 means log only an ellipsis.', + long_desc => '-1 means log statements in full. 0 means log only an ellipsis.', flags => 'GUC_UNIT_BYTE', variable => 'log_statement_max_length', boot_val => '-1', @@ -2368,7 +2370,7 @@ { name => 'password_expiration_warning_threshold', type => 'int', context => 'PGC_SIGHUP', group => 'CONN_AUTH_AUTH', short_desc => 'Threshold for password expiration warnings.', - long_desc => '0 means not to emit these warnings.', + long_desc => '0 disables these warnings.', flags => 'GUC_UNIT_S', variable => 'password_expiration_warning_threshold', boot_val => '604800', @@ -3580,7 +3582,7 @@ { name => 'wal_sender_shutdown_timeout', type => 'int', context => 'PGC_USERSET', group => 'REPLICATION_SENDING', short_desc => 'Sets the maximum time the server waits during shutdown for all WAL data to be replicated to the receiver.', - long_desc => '-1 disables the timeout and waits for the receiver to catch up; 0 does not wait for the receiver to catch up.', + long_desc => '-1 means wait indefinitely. 0 means do not wait.', flags => 'GUC_UNIT_MS', variable => 'wal_sender_shutdown_timeout', boot_val => '-1', @@ -3590,6 +3592,7 @@ { name => 'wal_sender_timeout', type => 'int', context => 'PGC_USERSET', group => 'REPLICATION_SENDING', short_desc => 'Sets the maximum time to wait for WAL replication.', + long_desc => '0 disables the timeout.', flags => 'GUC_UNIT_MS', variable => 'wal_sender_timeout', boot_val => '60 * 1000', -- 2.55.0 --OzAxZwZk1264o+ni--