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 1w9zuu-001y9S-2N for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 06:28:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9zut-00Ey6D-13 for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 06:28:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9zus-00Ey64-2a for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 06:28:03 +0000 Received: from fout-b5-smtp.messagingengine.com ([202.12.124.148]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w9zur-00000000z5m-1kaF for pgsql-hackers@postgresql.org; Tue, 07 Apr 2026 06:28:02 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfout.stl.internal (Postfix) with ESMTP id C3FBA1D00243; Tue, 7 Apr 2026 02:28:00 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Tue, 07 Apr 2026 02:28:01 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1775543280; x=1775629680; bh=xxpUZdak10 b0ZdwLW+fF2Y4goOL9OG25rsA+8HRCO7w=; b=Lf6sLU/YqotoUAHuHpNyq5/jMg lxnSzb0WrxSl4KzJofolsdp0uNNVzK4OJr7eekjG9WzD8OCO4eYcFN/r3cPkCAxE ZRf/viKDvmtXGGYINyeDKjEKNoAL5U8vJ9U/cUU81FqqWEVOTSDwFSMTys46hhbH hyfgorDvtHHT9h7bBeuwyaQCs7Ilqrcslkfim5f13cBnfNYhtfjXJ9hxi5FICxAZ 5EUcp5DPJsyW8Facu80UFvZy0HfKyqJFIObj7go6LVwoNmqbyJ+lrHl+emeLYqeF xnWXPr5+YowskDR+nGIT3S7NJpQrYau14EmxQBcSy9/cBxDh8ZuQNd82BEgQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1775543280; x=1775629680; bh=xxpUZdak10b0ZdwLW+fF2Y4goOL9OG25rsA +8HRCO7w=; b=qx3W/okafyqtSZnothzcQpS1WYCwAtz7RGIwI4zDuew63AbZjzu CMpa0B9bfBjo+3REIQ7AwZfJWqRYWcqGIfmPXDSoMJi0k0ECKU8YhFuoydMFEbaB T0jxVD+kmPD1imqVWc6fFaSe+YqgoB8PsumN60WZzMjbgC69KeH2spFkFT800hes 3AILJWgcMQfIUBqyGYbYK/Zb57Vn9ilNRyBsZVMXi+DKQuXKVOJEGrysbhuyBmLX Ff9nqJyT99JfSf4TtPe+Df104vMFH2lyVaTH7e7/LUz+0qgQBqrEgH78cE95IO87 5avjDr2xnnX7GN2bDvi9S5DRqoLTa2NC4/g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgdduleelvdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlh cuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddtvden ucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquh hivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeggeff hfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtnecurf grrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhn sggprhgtphhtthhopeehpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehsrghmih hmshgvihhhsehgmhgrihhlrdgtohhmpdhrtghpthhtoheplhhukhgrshesfhhithhtlhdr tghomhdprhgtphhtthhopeiivghnghhmrghnsehhrghlohgusghtvggthhdrtghomhdprh gtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrghdp rhgtphhtthhopehrjhhujhhuuddvfeesghhmrghilhdrtghomh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 7 Apr 2026 02:27:58 -0400 (EDT) Date: Tue, 7 Apr 2026 15:27:53 +0900 From: Michael Paquier To: Sami Imseih Cc: Lukas Fittl , zengman , pgsql-hackers , Julien Rouhaud Subject: Re: Refactor query normalization into core query jumbling Message-ID: References: <8437F4D0-9DFB-4045-9318-CC3C5BA2E267@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Wo6ucqGDdYltCirN" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Wo6ucqGDdYltCirN Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sun, Apr 05, 2026 at 05:13:40PM -0500, Sami Imseih wrote: > I took a look at v9 and it LGTM. I can also see that v9 had the idea to discard quite a few of the edits I did previously. Restored that, reworded one more place that was refering to query normalization in ComputeConstantLengths(), applied the result. We're in time at the end. -- Michael --Wo6ucqGDdYltCirN Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnUo+kACgkQnvQgOdby QH2zoBAAjkldd7s7m900nqeg9g4ii6S65SaxXcZ2a3HjpWsd/OxhK4lT7H61wqsZ 2PhbxowTPrSD+L4ICvqPKBADOoXlUX+g71ISWSNptPnSPd4A2S6pPzZWqeE6Eiln xNQ2DzvBpkix4Qd9Pg1VA9Smnftw0iBgIOrtlheVmkOYtSC6XBWmCk6mdBfrAmGX psqHKiO/XLbz3kHj+6a5gx2pCGYwbMAOTq2Z1yrMSuQl0VA57s5qhUasVLBU4gVq Ye/advzR6/Vkx1QGeR6IAzYpa/Tt5awJzTOSlUu7+YfyMEu+cG/LArcM1NQ8fqcy tV5R0lEDMBnMO+Xgr6Wch3ZhURRdf53g2DBvl6nwvNxCb8UbdwfX0VZuC6+oxHwQ w9tdO75wNqNqVGa2SGGkXlglj46bNOz5NVH4wPEsFXy9OYgRsjtH3uLcSnQSP9Uc DLtjbzGSHaxiD4/Ej7a/xDuTsUJkMKcDdC6Td6ra7nIX/yEuwzCBR2lbImVdgjZP ZdkLU4oJEjm2bMIlSZGNdeIzrVgxpEhwRewFm2PJrsf3RA4O4FK/cV0z5kezXcKV FbKmXdafKeyk9PIXy9ZKC7wLS0oKyYAQspHchnt0j4EiOPm9fNdOsdUIIUcYoqf9 xM6kyj7lOjoWNvkeJKM+r0sNLSXUwXHr+cEXqyAq7vJyz48occ8= =bdZ2 -----END PGP SIGNATURE----- --Wo6ucqGDdYltCirN--