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

From Sami Imseih
Subject Re: Squash constant lists in query jumbling by default
Date
Msg-id CAA5RZ0v5VqUo_ew-fNA1HDF4Lo=7UtEyoT_SYOPjYFcjmDfE2Q@mail.gmail.com
Whole thread Raw
In response to Re: Squash constant lists in query jumbling by default  (Álvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
> > 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.
>
> I have no problem making it superuser-only, and I can see making "on" be
> the default.  I am not opposed to removing it completely either, if we
> really think that the current behavior is no longer useful for anybody.

I am in favor of complete removal. [1] will change the behavior of table
jumbling without introducing a GUC, and I don't think we should introduce
a GUC for the squash values case either. Why one behavior change is configurable
while the other is not? seems confusing, IMO.

Also, as a matter of principle, it seems most are favoring not
introducing GUCs to
configure queryId behavior. I agree.

[1]
https://www.postgresql.org/message-id/flat/CAA5RZ0uNofEXfEfNw3uRN3D3oXkFPQ_s%2BhuLLHMKR_%2BMCk8RPQ%40mail.gmail.com#c357c56c3924642e8ef73cc1c8a0286e

--
Sami Imseih
Amazon Web Services (AWS)



pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Statistics Import and Export
Next
From: Dmitry Dolgov
Date:
Subject: Re: Squash constant lists in query jumbling by default