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 1qpgQn-006YcL-TS for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Oct 2023 02:55:42 +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 1qpgQl-00A0HY-Py for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Oct 2023 02:55:40 +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 1qpgQl-00A0Gx-Fc for pgsql-hackers@lists.postgresql.org; Mon, 09 Oct 2023 02:55:40 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qpgQk-0010yB-4V for pgsql-hackers@lists.postgresql.org; Mon, 09 Oct 2023 02:55:39 +0000 Received: by mail-lf1-x134.google.com with SMTP id 2adb3069b0e04-50307acd445so5057089e87.0 for ; Sun, 08 Oct 2023 19:55:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1696820137; x=1697424937; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=1Vl6YmigKXwSP+9itxsePruiOIgVJkegGmwJAzhM8/4=; b=ei8StGjkh1bs8bHXFl+ASaYjDyygT/fkLMTRWnplZq4gRdpwJ1IxMVyv6YDZbzydc8 qC99LvULL8k9l8ZFxtKJ1Cv6P7DfgQwIUAOnMkriDe7TcapzurCXetk7vGSefpiYJfwI nklD0tqWMEoecZLuGoIhRvW9ndJGqdp7moJkzMdLjsg647yfaOeOcU80zSHWuwlBDLvW Nuh0HymMAhgmYABhsxj1WRz3sJd/xpKjQL1pHtGgPxNeDOxaFw5jNjgRPyqAHi2QwrSf KvctmjNvc2Jow1lag68BYDh2qKyyex4+t1U8A08ZzooP6X+Do4LtejwxCd/P5QOyU48s PE0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696820137; x=1697424937; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=1Vl6YmigKXwSP+9itxsePruiOIgVJkegGmwJAzhM8/4=; b=QKgyNKn9AZy1/0bDahugc+vQl8jsunW/2pKLyycjDHsgZd/tPD0rwlV6WH/0ru1ANZ h2DY9eP8jZ6NTDgqxRJOEsKNe9Kq14ordjUmVxBLiYFBDtV7jBYOBNQJS8L2WvkOs7DU 6tiYALXt7Y85DPKbe/EyqNn6GwM86SzL7lqGmNFvcSWzAc8Q6JFHnYnO8zEP8RtRuiib yU5kvrcZFG2mmgEueEpBN36RoXjq8d6d4K8CMWnnZvinceUv8ZPk1bDS3rXLTnHjkVrM S3R5oFm6LtdKdoFWoPJk9qBxrnGnCm1TNntISkSdFUAU0YciRQkMm/mUQ1FrjmmXK0KF BTEw== X-Gm-Message-State: AOJu0YxLlfVWwn2iIyOKMxQ8/uBxpCwDV87seQ5USn2T9jxYdRMkaU4W DyAzgN5s7tgy18WH9YD5eyzl7Y4u8XzW8hgo3Tc= X-Google-Smtp-Source: AGHT+IHS2vFCwHSTHtXIKLKXSFgvY+5DAaR20XVllE1jteORHGHY8s/Fzi+6E96QNuxA7jldhrhi1LNBGEo17aqK3jE= X-Received: by 2002:ac2:44cb:0:b0:4fe:279b:8a02 with SMTP id d11-20020ac244cb000000b004fe279b8a02mr11733679lfm.67.1696820136761; Sun, 08 Oct 2023 19:55:36 -0700 (PDT) MIME-Version: 1.0 References: <1104459.1695938385@sss.pgh.pa.us> <3363970.1696800505@sss.pgh.pa.us> In-Reply-To: <3363970.1696800505@sss.pgh.pa.us> From: David Rowley Date: Mon, 9 Oct 2023 15:55:25 +1300 Message-ID: Subject: Re: Does anyone ever use OPTIMIZER_DEBUG? To: Tom Lane Cc: PostgreSQL Developers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 9 Oct 2023 at 10:28, Tom Lane wrote: > > David Rowley writes: > > It looks like nobody is objecting to this. I understand that not > > everyone who might object will have read this email thread, so what I > > propose to do here is move along and just commit the patch to swap out > > debug_print_rel and use pprint instead. If that's done now then there > > are around 10 months where we could realistically revert this again if > > someone were to come forward with an objection. > > > Sound ok? > > WFM. Ok. I've pushed the patch. Let's see if anyone comes forward. David