Re: Squash constant lists in query jumbling by default - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Squash constant lists in query jumbling by default
Date
Msg-id 1282250.1742921593@sss.pgh.pa.us
Whole thread Raw
In response to Squash constant lists in query jumbling by default  (Christoph Berg <myon@debian.org>)
Responses Re: Squash constant lists in query jumbling by default
List pgsql-hackers
Christoph Berg <myon@debian.org> writes:
> For 2), Tom said that configurability is 1) often much less useful
> than originally planned, and 2) tools have to cope with both settings
> anyway, making implementing them harder. Plus, switching at run-time
> makes the result even less predictable.

To clarify that last bit: if some clients run with the GUC on and some
with it off, you have a mess.  Even statements that are completely
identical will have different query IDs under the two settings.

If this GUC sticks around, it should be at least PGC_SUSET (on
the analogy of compute_query_id) to make it harder to break
pg_stat_statements that way.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: NOT ENFORCED constraint feature
Next
From: Sami Imseih
Date:
Subject: Re: query_id: jumble names of temp tables for better pg_stat_statement UX