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.94.2) (envelope-from ) id 1sRcGH-00H3zg-HZ for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Jul 2024 18:41:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sRcGG-0086CH-2R for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Jul 2024 18:41:52 +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.94.2) (envelope-from ) id 1sRcGF-00866D-Nm for pgsql-hackers@lists.postgresql.org; Wed, 10 Jul 2024 18:41:51 +0000 Received: from mail-io1-xd30.google.com ([2607:f8b0:4864:20::d30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sRcG9-001Qua-B9 for pgsql-hackers@lists.postgresql.org; Wed, 10 Jul 2024 18:41:51 +0000 Received: by mail-io1-xd30.google.com with SMTP id ca18e2360f4ac-7fe8d029fbeso3081939f.3 for ; Wed, 10 Jul 2024 11:41:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720636903; x=1721241703; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Cxds6mlqNeiDGAh/nZqrLXoNn7EG9Dbz5Tthgj6M62c=; b=O5KPrAIvCYPAwqHJvttuaUJQfAbV2OLbUV3Ax2dT8IUHXe+jO1m4zn1g08mSGGEQi1 7XRbIfczLQKbCGBw2D9M8Fse/tGvQSUeTmo4qUrir1Tl5psmD+0Sx7mvrIzahNY46OKq Ggg7SR4A5vdtP/UdcvrIhno/h3fhTs0KWzYDbmDJi7YaEuC3apfFQTrl9DfaFP15vVzn WCyTGnHd2apMnlwK53mk0QBKMe2zXPWI7THCjVj94CWQhWecMl1A3205YbYiixN2pacA H0VK4DfD6or04cBFJr7uGT0CWrfoyllUwn97Vjl3Fjfg4Spjl4ppHXR5Pu2pvZXn2rW6 Wc7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720636903; x=1721241703; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Cxds6mlqNeiDGAh/nZqrLXoNn7EG9Dbz5Tthgj6M62c=; b=v/882BgcGoVMPF3rD1CMd4EkOr8vl2jwhQlNTGnckRC/zii37fIhqQu6N8t26U9lXt nOCcrl1wxicJKg25rtKai8AXrjjVDfCBhKm36YVvsz5hpjfx6LggdxiAj+/EiXRYwiD/ e94TryBuzqIKKdAvJwWOtW1tucAQHf/uNRG1w6U9cIUEZZS+byZjL2Cnncrkrsfs7bXD cwTXUwjTmrKF3aAJZVDkww5vnS8zv+RKQ0t0OiqN9oFfrJhsrvHfTxCaNf5PZlee7c4B r0OHzScv7i5fQnqsSCDvV9pRuwkLIQDfK2PgZl++b67/XRNmLkZvXPo6x1Rc6xEhcbv9 cmgg== X-Forwarded-Encrypted: i=1; AJvYcCURdtPHXCrZtXCBisZ60H9/+YxzXkFC8gx23k/slknNrMozx5qW7g+lQz/8b+jwTdChy94KCX38M6ZLFi2qnOUm5ETA34NJATidpFgaZT9cP8Xh X-Gm-Message-State: AOJu0YyiQCuXB2t+/w9qrJ3B3BRg+gO5mRxhIKD5j04TG1DJKS4qbNjX qcc2p/fN4vX/2hmRBamexURdEYDhncVeWrEVwXPVYrs5BwWQGGsC X-Google-Smtp-Source: AGHT+IG8oMKfk+bPDDctG5i/HlBnSp6Z7wWA4IvkRsYJhOXjrOQJlqWwgti8iGXGk6VAqit9EaYxeQ== X-Received: by 2002:a6b:d606:0:b0:803:8353:a89b with SMTP id ca18e2360f4ac-8038353aaefmr481015439f.12.1720636903237; Wed, 10 Jul 2024 11:41:43 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4c0b1bf8416sm1317329173.91.2024.07.10.11.41.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 10 Jul 2024 11:41:42 -0700 (PDT) Date: Wed, 10 Jul 2024 13:41:41 -0500 From: Nathan Bossart To: Tom Lane Cc: Jelte Fennema-Nio , Robert Haas , Fujii Masao , pgsql-hackers@lists.postgresql.org Subject: Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Message-ID: References: <6e30082e-041b-4e31-9633-95a66de76f5d@oss.nttdata.com> <802ff3d5-fdc7-4b08-9046-2e9fc5fdae0e@oss.nttdata.com> <7c1b48d8-0f08-4733-a4e6-d55f04581db7@oss.nttdata.com> <1744272.1720624273@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1744272.1720624273@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jul 10, 2024 at 11:11:13AM -0400, Tom Lane wrote: > We went through a ton of permutations of that kind of > idea years ago, when it first became totally clear that cross-checks > between GUCs do not work nicely if implemented in check_hooks. > (You can find all the things we tried in the commit log, although > I don't recall exactly when.) Do you remember the general timeframe or any of the GUCs involved? I spent some time searching through the commit log and mailing lists, but I've thus far only found allusions to past bad experiences with such hooks. -- nathan