Remove the query_id_squash_values GUC
Álvaro Herrera <alvherre@alvh.no-ip.org>
Remove the query_id_squash_values GUC Commit 62d712ecfd94 introduced the capability to calculate the same queryId for queries with different lengths of constants in a list for an IN clause. This behavior was originally enabled with a GUC query_id_squash_values. After a discussion about the value of such a GUC, it was decided to back out of the use of a GUC and make the squashing behavior the only available option. Author: Sami Imseih <samimseih@gmail.com> Discussion: https://postgr.es/m/Z-LZyygkkNyA8-kR@msg.df7cb.de Discussion: https://postgr.es/m/CA+q6zcVTK-3C-8NWV1oY2NZrvtnMCDqnyYYyk1T7WMUG65MeOQ@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| contrib/pg_stat_statements/expected/dml.out | modified | +1 −1 |
| contrib/pg_stat_statements/expected/squashing.out | modified | +0 −33 |
| contrib/pg_stat_statements/sql/squashing.sql | modified | +0 −10 |
| doc/src/sgml/config.sgml | modified | +0 −30 |
| doc/src/sgml/pgstatstatements.sgml | modified | +2 −4 |
| src/backend/nodes/queryjumblefuncs.c | modified | +5 −11 |
| src/backend/postmaster/launch_backend.c | modified | +0 −3 |
| src/backend/utils/misc/guc_tables.c | modified | +0 −10 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +0 −1 |
| src/include/nodes/queryjumble.h | modified | +0 −1 |
Documentation touched
Discussion
- pgsql: Introduce squashing of constant lists in query jumbling 10 messages · 2025-03-18 → 2025-03-27