Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mu7xZ-0007T5-Jl for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Dec 2021 06:58:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mu7xY-0000QG-D0 for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Dec 2021 06:58:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mu7xY-0000Pu-31 for pgsql-hackers@lists.postgresql.org; Mon, 06 Dec 2021 06:58:48 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mu7xW-0006NX-PB for pgsql-hackers@lists.postgresql.org; Mon, 06 Dec 2021 06:58:47 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 3742632008FD; Mon, 6 Dec 2021 01:58:44 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Mon, 06 Dec 2021 01:58:44 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=1Gqz7kpI4u5nEsLhQla7MHze9LL tSHvg5IXdfyExkso=; b=RkDarSYe9oKvx8GeAkcB3wNho1mxkCSkQnTTElSDyxJ H4O61lqxy+Hzmn1t0Kk1PeM0OGja3ICnhK9zIxoyDR8h6m7uUfmw8tm2Ri/0g/9X HG1f/8k0HHVOUtONPws8aR+eUZM4CBHLu7n70/DSg6WTTzK/JwSBwvshtlLeLjoh rbCfX/KTBb7jRbkrvdd5l0wDO5cJxQi+gc0bjjklQDVVhq13sX/iF8ksQeu0y6KX fF+b3S7RKoUBu1oJtDvE3U++FwjeKHtS1bv+GmlOQHehJvq9iZsmbk0EbB3aQ4Mv UZctnUvlnfINXOq7GuD3DMSmHDtnyKKAtw3eGsBB8Qw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=1Gqz7k pI4u5nEsLhQla7MHze9LLtSHvg5IXdfyExkso=; b=Kk4NInmzXDGwj7M1VBI1RQ /N3Hxx4pwM9McczX/W0vi2xOwpe/vSUcdOkC9fDc0TWOMKjbIf37SlT2TpCn41GX /KZM2nV39fJuRx6rTbe+RvW1VEcZOoJeTOmbQr1W1Fv8utZRQhqKiPb73ZlOso+I 0FFPyLqOH+QSjU3cH2MA5Rg0FiyJQ5+c4v6bUPIFXfdsPVtVVU+baucHdiyKfFZN NCuH2JmM7GWhy/dR+YSIehtLoASVqvFWnXKJiLyxycGxcQgQSj2QAE1cS3dRm4GP CCg/TJm+0r4t2YdXxjWcuJORzs4nz06PTifG6BPBNzYsIu5NPkv4nuOLPvdyQpAA == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvuddrjedvgddutdduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvveduvdekueeugeekveeftddu gfelfeegfeeijeegfedtjeetvdeghedtudekveenucffohhmrghinhepshgrmhhplhgvrd hishenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehm ihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 6 Dec 2021 01:58:41 -0500 (EST) Date: Mon, 6 Dec 2021 15:58:39 +0900 From: Michael Paquier To: Justin Pryzby Cc: pgsql-hackers@lists.postgresql.org Subject: Re: GUC flags Message-ID: References: <20211129030833.GJ17618@telsasoft.com> <20211201075904.GW17618@telsasoft.com> <20211202033439.GL17618@telsasoft.com> <20211202051734.GN17618@telsasoft.com> <20211206053805.GG17618@telsasoft.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="puI4QP+r7HZeO9Kn" Content-Disposition: inline In-Reply-To: <20211206053805.GG17618@telsasoft.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --puI4QP+r7HZeO9Kn Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Dec 05, 2021 at 11:38:05PM -0600, Justin Pryzby wrote: > Thanks. One more item. The check_guc script currently outputs 68 false > positives - even though it includes a list of 20 exceptions. This is not > useful. Indeed. Hmm. This script does a couple of things: 1) Check the format of the options defined in the various lists of guc.c, which is something people format well, and pgindent also does=20 a part of this job. 2) Check that options in the hardcoded list of GUCs in INTENTIONALLY_NOT_INCLUDED are not included in postgresql.conf.sample 3) Check that nothing considered as a parameter in postgresql.conf.sample is listed in guc.c. Your patch removes 1) and 2), but keeps 3) to check for dead parameter references in postgresql.conf.sample. Is check_guc actually run on a periodic basis by somebody? Based on the amount of false positives that has accumulated over the years, and what `git grep` can already do for 3), it seems to me that we have more arguments in favor of just removing it entirely. -- Michael --puI4QP+r7HZeO9Kn Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmGttJ8ACgkQnvQgOdby QH2a3hAAgV5fSy5zk6ax/WLQQJGsT29XLcsV5D3wEs7rutcszIZtH83fYKUjtn1k 7ARs1/VUYAbFRHgEh0SY6XzcjOCA2pQnKsJDve3VUv/z6mc4Os0+8QT6Ww0LEG+i op48HcsRCuSa9U0CJEsR4zBJIQw4lavCwGZ+fmJdy5TMbciO2IVvZcVQokfxiZK2 rMomcgM1iBJZIwH1XVc1XWRf+Q+EXRYkj8E+f3YxboKIuK0qGCYFhdzmbb+Fm/NS /jFY/9z48M6YcBo/oAd0WRikcnFCkOCt40oV/yGkW0CAAWr8G6eVdLflbQAO35HA R45oEoe4y6FypLGUD6dh8gCGHU0xTjwKfKpRcYwmJq2M4Wyn2KyPo8udjsdivB4O qO017iIWldY7wVl7XfjrqaxvrAC441Z8W/It9EnzXDxWzq2ekpIYzUAzrwFcsIT6 PrtScO1naW7hPr7EB3yfDK725Xs8quzoGF+WAJD4jLlammtnsd0tqQ3KN/t5VwlR 4u1qXYX7h661WQC8BpnkC1jmmqM4Veaw8ThSkQQJ8HH3yzvPEzJwgqmjxvG4jM1F nWNzoDnLCduba3cg7AL0KbSw6zOERgXnHYozw0eIHGN0Jo0VelitDNuC8orAcuVg pUSJPnLLegGmuUpfDTTQaXFFSCdLVG6lJpMKFxKQjwJsftQKeUs= =hCPk -----END PGP SIGNATURE----- --puI4QP+r7HZeO9Kn--