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 1txBl2-004OI1-VG for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Mar 2025 21:24:25 +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 1txBl1-00ACo7-5D for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Mar 2025 21:24:23 +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.94.2) (envelope-from ) id 1txBl0-00ACgd-PH for pgsql-hackers@lists.postgresql.org; Tue, 25 Mar 2025 21:24:22 +0000 Received: from mail-ej1-x644.google.com ([2a00:1450:4864:20::644]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1txBkz-0017I7-09 for pgsql-hackers@lists.postgresql.org; Tue, 25 Mar 2025 21:24:21 +0000 Received: by mail-ej1-x644.google.com with SMTP id a640c23a62f3a-ac29af3382dso1034004466b.2 for ; Tue, 25 Mar 2025 14:24:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1742937859; x=1743542659; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=so6JRYnRm6xoT4dW+HYYZ3YDiTTywRYUFd/y5/T331k=; b=hU9huKrEKYuAzbcDZqGbdwh29Br3s5VnH1dR8S/qscS4gkSG8eOdD7QxZSlBzE2pDw UNzB3sbhJVBQvnkdKYn5Zy0rUeqtaOEg+aOrQxJS03r3dqQetdiJcG2l+8kDZ2uBwq3y 0rvgnWUWnDetboMEXKo8bHTUHdFuED7A/ULqjqspWJ1PSiT/KNhOjsmnCJoL8/Jz5eiQ nb9EWVnHbhgBQZfRyQ3OehDjVNPofGJ2E+8FnrM0poLqVgQDWFC85omr3XCMwGrFqE4q AjTIzT29WTkPvAVgYJwXZodDhb1qQ4mak3m/eIhB3eDcjS6IF5gMTS5WtkMfZ6si+E/4 55mQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742937859; x=1743542659; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=so6JRYnRm6xoT4dW+HYYZ3YDiTTywRYUFd/y5/T331k=; b=ukMTdMVk4IdcXJWwpcEn1yY96xspMTa6ClqKwFwFqcFCRRmBW4RsoDEwDHvhFHQD+Q IxpG/L9fC6Zt5lsuvqgX7T6zG4/1TnhIRrH6ukWztZjpZquiw1LCh26bYZ9j59PQk/F5 HarSfdYb5clWTJKL8NO8urs3sDa8Jsd5p+j0ec6TjcdPxGupWncWialCLRccUCmxrYK1 fQucTqrCzXadM3ZZIwggEB+M6HWOZjZYBH3Y6x+ffGkuAiSIwcCjTNf/39ZfmyhVYn4/ dhkyIuATEFKm+cUKkG9MfvOcoh734krDk9/IXlPJznWzG/r+y/op9xyUtPn7TX3sac4i fpcw== X-Forwarded-Encrypted: i=1; AJvYcCVTLu7W+8lYEv5ESKHKDCdx9mlB5/Q0Yk/Ac1TGcW3zLWor3+4iAXo0vEJMrvhpzBlgiG99oQuiUaIoBtCL@lists.postgresql.org X-Gm-Message-State: AOJu0YzZgDb+4bnAYrbpw2BAWetWNFpfjEiIqSkAc1smKL8eoAQM8cTV tkUKNw4PMs/LVsuD0QIU9Nq4GxBkIOlQg3hwGj7DTcYAYW3y0BfctR1wVk459qM= X-Gm-Gg: ASbGncujOF+mo8Fv2bwS1YX51wMDe1eJ0Nx0yAWHZFnlF3wBr5Ib+no/mEuz2wYbpYO 75BsZI9T19QP/aYrcy3t1arXZ1lGC6uEABEtuw0QvKnMTdCYCa0K9sLcFTc1VkUIH5z/GQmTd6o /IEJjuwxA42DwnVlduEyWcm/RBvXLFiL4xxFiDXG0EpXsPhKS0Pua6sVf20WaZwBlRZssXxCbY3 7kU6UWVCJMfXyp7AKcZ1Hg+BVUEdSofLJnYWvMpHSOH2GhVFt1/fmJCUw1f4wyOn8Ky2JMFfoJz b4W+B2tNtZkhGyX/PWDbOn0wb1+Ej4tv7zLGp602w5bbl1IgITKKHuh0HYUNUtQpZlJ6r8a0l7W wcqvtEfTnw0+enn27NIL0 X-Google-Smtp-Source: AGHT+IFvUM17gTe4/m99Imv4xA6pjTa/u9NUBvsH5lPts1nmC9fU+cay4A3yPho1C0nQz7tmcHfqMA== X-Received: by 2002:a17:907:805:b0:ac2:9aa4:2ce4 with SMTP id a640c23a62f3a-ac3f251f23amr2014681966b.53.1742937859129; Tue, 25 Mar 2025 14:24:19 -0700 (PDT) Received: from localhost.localdomain (46-253-188-4.dynamic.monzoon.net. [46.253.188.4]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ac3efb64952sm916022466b.105.2025.03.25.14.24.16 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 25 Mar 2025 14:24:18 -0700 (PDT) Message-ID: <60b4f5d426b03e0a8b6e93413cc770c69cdc226e.camel@cybertec.at> Subject: Re: Squash constant lists in query jumbling by default From: Laurenz Albe To: Christoph Berg , pgsql-hackers@lists.postgresql.org Cc: =?ISO-8859-1?Q?=C1lvaro?= Herrera , Sami Imseih , Michael Paquier , Tom Lane , Julien Rouhaud Date: Tue, 25 Mar 2025 22:24:15 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2025-03-25 at 17:28 +0100, Christoph Berg wrote: > The "jumble names of temp tables" thread was briefly touching this [1], > I'm starting a new thread since the others are already very long. >=20 > [1] https://www.postgresql.org/message-id/flat/CAA5RZ0uNofEXfEfNw3uRN3D3o= XkFPQ_s%2BhuLLHMKR_%2BMCk8RPQ%40mail.gmail.com#c357c56c3924642e8ef73cc1c8a0= 286e >=20 > Two points were made: >=20 > 1) this should be on by default > 2) there should be no GUC for it. +1 on both Yours, Laurenz Albe