Re: Refactor query normalization into core query jumbling - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Refactor query normalization into core query jumbling
Date
Msg-id 8437F4D0-9DFB-4045-9318-CC3C5BA2E267@paquier.xyz
Whole thread Raw
In response to Re: Refactor query normalization into core query jumbling  (Sami Imseih <samimseih@gmail.com>)
Responses Re: Refactor query normalization into core query jumbling
List pgsql-hackers

> On Mar 28, 2026, at 2:09, Sami Imseih <samimseih@gmail.com> wrote:
> I agree that ComputeConstantLengths should be in core. This one is
> not a gray area IMO. The query jumble already records constant locations,
> but leaves the lengths unset. ComputeConstantLengths is just the
> completion of that  work. There could be no other interpretation,
> unlike generate_normalized_query, of what the lengths should be.

This is an interesting remark. One problem with any patches presented yet is that we don’t attach the lengths as part
ofthe in-core query jumbling procedure: we plug the lengths later using the same structure as the query jumbling. It
seemsto me that this is half-baked overall. I think that we don’t want to pay the extra length computation in the core
queryjumbling at the end, then why does it make sense to include the lengths in the JumbleState structure at all?
Shouldn’twe use a different structure filled inside PGSS for this purpose rather than reuse the same thing for PGSS and
thein-core part (don’t have the code in front of me now). 
--
Michael





pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
Next
From: SATYANARAYANA NARLAPURAM
Date:
Subject: Re: Add pg_stat_autovacuum_priority