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 1wA0Iv-001yU1-2P for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 06:52:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wA0Hs-00F32H-2U for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 06:51:49 +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 1wA0Hs-00F329-1T for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 06:51:48 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wA0Hq-0000000131X-1zfU for pgsql-hackers@postgresql.org; Tue, 07 Apr 2026 06:51:48 +0000 Received: by mail-qv1-xf33.google.com with SMTP id 6a1803df08f44-8a016799d2cso63182436d6.1 for ; Mon, 06 Apr 2026 23:51:46 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775544704; cv=none; d=google.com; s=arc-20240605; b=STggR7os/+ryQLxJosKa1yfbB+wj9ccHN6JSEaTz2pRN0xqhK2ccg3BMVEWMO9MAum FBO2avG2v9FC6dEtu/LqIWbsMfhyy38VMiRHgcA9faPaofYKjO9yeYjsqSrFxgaCCFHn m6o5BnLi4nSHeKSD93z0TQjujh7RlnrOnTNgMb7GHebcaR+6iS1EqxOHmTTLACBT7Wyw o1txxGqqNGO/SPYT3aZU3ZD/4wjlVHQxQQcJsOeQqd8S9Q235uVsKU0x5QXSktiUnGGM rfk8W2hD5rfrwMbfvqjWG0hL1L+FW+kEF4xBbQGWXlmyg/UmlOjxqNNWiIau75a/wwp5 7T8A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=Eh/wlJxDwJ3RVwk4X8BNlN+CgW+N8O3guqLkEyE2RMQ=; fh=g0U9nufaayURIKIuTWLF0g8nOvLd8nUThGMqFogtCPA=; b=G+Wda0TV50I1kMBpvDkmC9j5aLJ1FBd93B8F2UGRje8pLOJLSp8CSb3jRDuqYwgOVm zMfgL04V9oSRkLyZShpf+QSP6yEGpVXtbreCEjCFwKLFJM6/+HJqK1ByCf3MZdtkSrvy MjXtmt0j9R/36SxJD9tjsbdffjgTylZ8zty97C+BWPNoKzIWGkAqUXowhWKXDeBEfeyA XWsiFFjDk5dfaiBSxgbODJaz3wPnE8kdxhLNoBGXycgWjPHOaHTpXLdWVVH/h4IYRjJl e3nUAKn/GdtdRGym+SNff3N/EIgIeb+YOmlbu6t3ZtgMANWv/PXp3vJJ6OJ4k8zbX7rB 16lA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fittl.com; s=google; t=1775544704; x=1776149504; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=Eh/wlJxDwJ3RVwk4X8BNlN+CgW+N8O3guqLkEyE2RMQ=; b=ckKAoB0ySctNI39Xc7SOZinpdBKGNGaqxJVK2bBY8CTRAR+SmFYMFzvkxj1NZvU7WD /S+fg1eu/Nm82FX1sH5yvkj2dAGSPiA7tc8GMwINuf0ow51em0SCJZDigZHAOcJebMh+ BXY5lXwe1RwaiX7achUJT8C9jyj2uJU2GgOks= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775544704; x=1776149504; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=Eh/wlJxDwJ3RVwk4X8BNlN+CgW+N8O3guqLkEyE2RMQ=; b=EfssVcVgWT8jUfx36KK4WtU3KkheN3ztVr49v5hkl+eRbAwzqQozYStpMPq5IVxhc5 WValyJxXAVi7QGX+520YqY8OehN94JINM/OEhtKjbbqnNmKhVjcjIJY0xMp1aN7RM4wf rm+0jbsk53by7WTW2nCTsFAZ3F1iKLUhgpfbHA0foHcJugTstSBmKL3YoEap58DRPAxE +kG9ZLSvcY1dzfelIL11bHRZx4Twgee/kxRarA5YlAmFcafQMyh8XFVHx2KCbJAjESkg PVkqBvwlDIUVP47UaYm1Lpojg9RBWog/clAa7p7yd4tv7kd+COh95l68EJNy71KY5HuK wsIA== X-Forwarded-Encrypted: i=1; AJvYcCXGAAR/A2+V34iYz/XVXBj//+9NYjWoiu7TJzt2CmNQejx7oFqP/m6XmJcYojrcwuiUEjyOvQ64G234scDt@postgresql.org X-Gm-Message-State: AOJu0YwSLbUp75O3VcbNpxWoXd5CVppwtH74wwWGIW+KJHCbaKQyH2+o MTzZNYlGSSfiV2t9YFgVvExUIZnpH1rCrgouN9Qhwm8hboiyGFDYfjoPXAZnYcTR4FCR56yVAOL 1tpBAB/7dOUli9FwoaQ87qy+0B5B99/j7ExaoeKia X-Gm-Gg: AeBDieuA4TpFwHE2m5HJrz1zrtAKEBoyk0sdNgkGcKLr6816fDk7R9qOnysauLwZlwt Y+uKyGmaMLsuLBnLi+PMGBlY8uTRp5tQqDpq2zgKz0/+zB6j6Icq7t9ctBb27q8l7la5+VpVjei tGDy3AUAokKruHGO3NX4tx5M8E30b2zUwebzKu2B6bgJiAE/EEzp0hOI8sKD+zsFqqLX2IsoGe2 iUhIZb13Oy0sb1Nw9TVegWDJrltJOdagANFNxSMZsHzJCWQ9tVrOKv1gyefT5IkiUMfMuE2KasU yECxhUZ1ePBPi9HF71YzP4pF+ZUVHySOLzBP335ah7PAVRmWT/E= X-Received: by 2002:a05:6214:400a:b0:89a:f92:b09f with SMTP id 6a1803df08f44-8a7022bb7a7mr261343356d6.4.1775544704116; Mon, 06 Apr 2026 23:51:44 -0700 (PDT) MIME-Version: 1.0 References: <8437F4D0-9DFB-4045-9318-CC3C5BA2E267@paquier.xyz> In-Reply-To: From: Lukas Fittl Date: Mon, 6 Apr 2026 23:51:08 -0700 X-Gm-Features: AQROBzCvEHi_zVMN_hKwDx9R5SGU0YlkDEli6z3d7Upx0oTsCRon6uTR3677hPQ Message-ID: Subject: Re: Refactor query normalization into core query jumbling To: Michael Paquier Cc: Sami Imseih , zengman , pgsql-hackers , Julien Rouhaud Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Apr 6, 2026 at 11:28=E2=80=AFPM Michael Paquier wrote: > > 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. Thanks for getting this in! (and apologies that I dropped your edits, I was looking at Sami's v7 version when I put that together) Thanks, Lukas --=20 Lukas Fittl