Re: compute_query_id and pg_stat_statements
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>,
Stephen Frost <sfrost@snowman.net>,
Magnus Hagander <magnus@hagander.net>,
Bruce Momjian <bruce@momjian.us>, Christoph Berg <myon@debian.org>,
Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
Fujii Masao <masao.fujii@oss.nttdata.com>,
PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2021-04-26T18:21:00Z
Lists: pgsql-hackers
Andres Freund <andres@anarazel.de> writes: > I think that's the right direction. I wonder though if we shouldn't go a > bit further. Have one guc that determines the "query id provider" (NULL > or a shared library), and one GUC that configures whether query-id is > computed (never, on-demand/auto, always). For the provider GUC load the > .so and look up a function with some well known name. That's sounding like a pretty sane design, actually. Not sure about the shared-library-name-with-fixed-function-name detail, but certainly it seems to be useful to separate "I need a query-id" from the details of the ID calculation. Rather than a GUC per se for the ID provider, maybe we could have a function hook that defaults to pointing at the in-core computation, and then a module wanting to override that just gets into the hook. regards, tom lane
Commits
-
Allow compute_query_id to be set to 'auto' and make it default
- cafde58b337e 14.0 landed
-
Move pg_stat_statements query jumbling to core.
- 5fd9dfa5f50e 14.0 cited