Horton

Re: Squash constant lists in query jumbling by default

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@alvh.no-ip.org>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Christoph Berg <myon@debian.org>, pgsql-hackers@lists.postgresql.org, Sami Imseih <samimseih@gmail.com>, Michael Paquier <michael@paquier.xyz>, Tom Lane <tgl@sss.pgh.pa.us>, Julien Rouhaud <rjuju123@gmail.com>
Date: 2025-03-27T08:47:24Z
Lists: pgsql-hackers 
On 2025-Mar-25, Laurenz Albe wrote:

> 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.
> > 
> > [1] https://www.postgresql.org/message-id/flat/CAA5RZ0uNofEXfEfNw3uRN3D3oXkFPQ_s%2BhuLLHMKR_%2BMCk8RPQ%40mail.gmail.com#c357c56c3924642e8ef73cc1c8a0286e
> > 
> > Two points were made:
> > 
> > 1) this should be on by default
> > 2) there should be no GUC for it.
> 
> +1 on both

Well, the votes are quite clear, so I have pushed Sami's patch.

Thank, everybody!

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"That sort of implies that there are Emacs keystrokes which aren't obscure.
I've been using it daily for 2 years now and have yet to discover any key
sequence which makes any sense."                        (Paul Thomas)

Commits

  1. Remove the query_id_squash_values GUC

  2. Introduce squashing of constant lists in query jumbling