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 1wA9Ot-0026pR-00 for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 16:35:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wA9Or-001WlZ-1T for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 16:35:37 +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 1wA9Or-001WlR-0Z for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 16:35:37 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wA9Oo-000000018pt-33Lt for pgsql-hackers@postgresql.org; Tue, 07 Apr 2026 16:35:37 +0000 Received: by mail-ed1-x532.google.com with SMTP id 4fb4d7f45d1cf-66bd4f7b2d3so6275043a12.3 for ; Tue, 07 Apr 2026 09:35:35 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775579734; cv=none; d=google.com; s=arc-20240605; b=LhT3Gh1s09coquUj0CVw++/B8E8xBE4scZgaebnmRT+xbR4igNEhbAyjJ+d6goVy9Z +LU5vwTJnU8kx/L5SGMVzOOsyU8F++Fe5eFkW01ZBu4y0iR7kReQ7nqnpqeN1n4YQakW QZkVoURWZiK5g9wfPgMhNC+WrMCinJfLhhMGf2P/3dmTgM9vR03279QJHQWEn9sdpY8T 3MX0xnGKEigYxIvRJf9opH5HLLdN6ZKHrzSj+bWj4deA+5lU5uCOB+2SjhxoaNSsFA6c n9U+IQHJwf/u5tpt6tZQaHGyArCG1qaUJfjoYkeUpN0cMRhxlIfSewdSUd7xrQsNzpw0 dWFQ== 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=jHP65MBWnBeQpl+RZZTLZxs7E4z961C4tziibuQfE78=; fh=IsCr2TQrvmhrk71/CgwvkJPc7AdYDwt9kr7tir5DzvQ=; b=dDQElW4zpyunArur5lZhiH7ezulFy+DhUwAsvSRj0kvIkfu4v+L6MbSFecnuFA93OU /0lJnwmdfBqXPCi+c/EAG619GPeLzOxmv8FzrXLZss+cKPOTg4L1YWNjoBxS0YtAg/km izuaG6NJZvrvICbqVSHztPiGFFCeHxI8GAgkH6bMwz7jiCceBVIGuBYJeTBxL46Sl0Pg 7gDJqJm8sN1m7hyQxuwHo3RqHdd4OrtmIefEow262dpZFOoJBwvkq4CQv1Aatf2CYixw RVtNt8l0uCJtjb7CBJMLRujbzzS89uNa6lwmL2VCPGVq7Zw56jCCFQ+kRge/p5geIQRf os9g==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775579734; x=1776184534; 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=jHP65MBWnBeQpl+RZZTLZxs7E4z961C4tziibuQfE78=; b=dvidRZ12gRmTxBPbzBAe1KhSWaiNqep/Io/vmOmnn/WNOHzmpVUFC+08PqImodYbfe YVy8SzpAnaB16XjJe+AhWQbJluw+LU7s3SKkj5PKdzNb7M0lQLrcY8XYm4fhazedsAc1 AgwSvdeAcAvyS3kDj44tRJyrlm7/Hsov2FD81VniKTZbwSa2vRNWbyx/nHZ3Oo6JEjSl SalVqbsoNDxdCtEvUIh04MH5sr/hLKL8onqrgh8IsWdwkJEhmw/oO0OoVHGnhbfazpmc 5BgmaLxynXivcvKo834YOqBF3F/6oLJL2yQilRd9wsbIYXcDVlZKVrzVUtaO6I5R12EA uG9A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775579734; x=1776184534; 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=jHP65MBWnBeQpl+RZZTLZxs7E4z961C4tziibuQfE78=; b=BhCMsigVtJL8MG556oOCJmQOl4NbJ2O38mxu7RauGVW3kWwvBVUrxizoMgKIthyVPN EfkLBX+348d+YDdwNj8oIy+XqZ7gNyK2529cPLBATi60nqw7V2VcRSN9dND/KiJDd4hT YA6aomkiIIvj7Ic9QM0xa3krE8nvz+GDALCunUROK4Z8hhZdiDjkYmwwuFxn+FQq1BZQ x+0D1ZketgWmouS8KH90K9sd2SPjQB18Ptoh3uBb764oOhwBK+itB6AsNxLMLiSpJqfp 3A84Xaf+Z3pcK1CriLte4b1eGMrE6Mh7dJzVVvswZb88HYJjCZ7xvCYIIMEwlB6KfbKY EJFQ== X-Forwarded-Encrypted: i=1; AJvYcCWKHiHEqS3T+Qyg50n9Y1VLBU5oAkgdAQyCTgttIbtEHAin7C67IpQJsbq5+Uapd2ZkFL61BPMG6JgQjWod@postgresql.org X-Gm-Message-State: AOJu0YzyO1I6gAiIIlLExvuhqU6VMN3myPiGxZm3u7Wbrk9x5IOF/lN/ iYyHxZ380+uVv1zIVdnIxa6yqR5pYK3dGvCKcQyoKUSo42WW/2UXe1zcN2NxakE8oDV0HCYkbsN EGDKybISoBiNQtmsI4ndnN9NLZye7W7A= X-Gm-Gg: AeBDievHrhjZT/HzE0EEvXCbbS8lznbreGd7kK0+r2FF8qYVB3okfA2VezD0kMve3qB lEnRAdfwE0L+6AFyaDF2RdEJmHd7t+hY1JPtl+pCz9CkYxb/PKNiMTyM8Bq7Zgouq1UsXxyTsAr 3o4SqsPZ8WrFkMAT4PN2NA4aqNC1wav1zHoSNd4X+CqI9yDwhSdlbUf6un4qtNc9QmUspYw8vkS 99rAg0H57hID/MWbrZDRoNtCcRLxdP9AVcIoTK1XCJuftCqgRLcyL3Nh0iQydbx6+M879EnBk7b Ij0pA5GucSepDANd X-Received: by 2002:a05:6402:1468:b0:66d:d25e:6588 with SMTP id 4fb4d7f45d1cf-66e3f70229amr7731339a12.13.1775579734191; Tue, 07 Apr 2026 09:35:34 -0700 (PDT) MIME-Version: 1.0 References: <8437F4D0-9DFB-4045-9318-CC3C5BA2E267@paquier.xyz> In-Reply-To: From: Sami Imseih Date: Tue, 7 Apr 2026 11:35:22 -0500 X-Gm-Features: AQROBzBT-hVgv9uaOwz6imJ_skmGjbOqw9uqFxFaZJh03paLZSrKy51iCais7SQ Message-ID: Subject: Re: Refactor query normalization into core query jumbling To: Lukas Fittl Cc: Michael Paquier , 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! Thanks Michael and Lukas! -- Sami