Horton

Allow compute_query_id to be set to 'auto' and make it default

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

View on postgr.es
Commit: cafde58b337e007cb6a719f5ab4dd6459d932a39
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2021-05-15T18:13:09Z
Releases: 14.0 
Allow compute_query_id to be set to 'auto' and make it default

Allowing only on/off meant that all either all existing configuration
guides would become obsolete if we disabled it by default, or that we
would have to accept a performance loss in the default config if we
enabled it by default.  By allowing 'auto' as a middle ground, the
performance cost is only paid by those who enable pg_stat_statements and
similar modules.

I only edited the release notes to comment-out a paragraph that is now
factually wrong; further edits are probably needed to describe the
related change in more detail.

Author: Julien Rouhaud <rjuju123@gmail.com>
Reviewed-by: Justin Pryzby <pryzby@telsasoft.com>
Discussion: https://postgr.es/m/20210513002623.eugftm4nk2lvvks3@nol

Files

PathChange+/−
contrib/pg_stat_statements/pg_stat_statements.c modified +6 −0
contrib/pg_stat_statements/pg_stat_statements.conf modified +0 −1
doc/src/sgml/config.sgml modified +7 −2
doc/src/sgml/pgstatstatements.sgml modified +5 −9
doc/src/sgml/release-14.sgml modified +2 −0
src/backend/commands/explain.c modified +1 −1
src/backend/parser/analyze.c modified +2 −2
src/backend/postmaster/postmaster.c modified +3 −0
src/backend/tcop/postgres.c modified +1 −1
src/backend/utils/misc/guc.c modified +28 −10
src/backend/utils/misc/postgresql.conf.sample modified +1 −1
src/backend/utils/misc/queryjumble.c modified +21 −0
src/include/utils/guc.h modified +0 −1
src/include/utils/queryjumble.h modified +31 −2

Documentation touched

Discussion