Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lhFDL-0006E6-MJ for pgsql-hackers@arkaria.postgresql.org; Thu, 13 May 2021 17:33:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lhFDI-000248-Vn for pgsql-hackers@arkaria.postgresql.org; Thu, 13 May 2021 17:33:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lhFDI-000240-No for pgsql-hackers@lists.postgresql.org; Thu, 13 May 2021 17:33:32 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lhFDG-0006q1-4t for pgsql-hackers@lists.postgresql.org; Thu, 13 May 2021 17:33:31 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id DEC0A5F7A3; Thu, 13 May 2021 13:33:27 -0400 (EDT) Date: Thu, 13 May 2021 13:33:27 -0400 From: Stephen Frost To: Tom Lane Cc: Andrew Dunstan , Fujii Masao , Julien Rouhaud , Bruce Momjian , Pavel Stehule , Kyotaro Horiguchi , Magnus Hagander , Michael Paquier , Andres Freund , Alvaro Herrera , Christoph Berg , Peter Eisentraut , PostgreSQL Hackers Subject: Re: compute_query_id and pg_stat_statements Message-ID: <20210513173327.GD20766@tamriel.snowman.net> References: <20210513005236.aj7n6b76yjsxythc@nol> <20210513011325.GA11075@momjian.us> <20210513015700.fp33q5rfvwl2ahfx@nol> <20210513030652.GB11075@momjian.us> <20210513031613.j47baglf6xl3mgbs@nol> <20210513033332.GF11075@momjian.us> <20210513040342.fouh7ryglrfgxglu@nol> <1576471.1620926236@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4uYDHwxeWVfU+JOj" Content-Disposition: inline In-Reply-To: <1576471.1620926236@sss.pgh.pa.us> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --4uYDHwxeWVfU+JOj Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Tom Lane (tgl@sss.pgh.pa.us) wrote: > Andrew Dunstan writes: > > The only thing that bugs me is that we're pretty damn late in the > > process to be engaging in this amount of design. >=20 > Indeed. I feel that this feature was forced in before it was really > ready. I'm coming around to have a similar feeling. While having an alternative query ID might be useful, I have a hard time seeing it as likely to be a hugely popular feature that is worth a lot of users complaining (as we've seen already, multiple times, before even getting to beta...) that things aren't working anymore. That we can't figure out which libraries to load automatically based on what extensions have been installed and therefore make everyone have to change shared_preload_libraries isn't a good thing and requiring additional configuration for extremely common extensions like pg_stat_statements is making it worse. Thanks, Stephen --4uYDHwxeWVfU+JOj Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJgnWLnAAoJEO1sijiDR2RVrS0P/RECyOBu8II+LIcjwAbLf6wp HGZTo9ef4zuukkiEOCG8hb0zroftpMunXpbloAaFIhMDfqkie+YU9gwfVUl8vvfX FttCeIOXotz7+IT6PMVRYb5Zj5+XOAu4c6bMa4sp36oQfWiSvxcXAHUr/HS+XuGa e3eTz7+jf+/Rg40yOWT7EQiPccKuDLPjeLJsCfFbG8g772BEkASRGddvyzl6PBcG /sM7F2gG3Hg9lehrY/6sIljLq/PnnbBGKx+4eNSdQuZC5fbClC7C4uyx5EMOcn6c 5y3NXgatgRuOwViZneWBiaWx2wCRdLCBU8z/n9RBHNRM9bZR2P0PhR3Hv0k2X68I 8LS8Nlu2uiiDk89eWE47jnu70hsH7+YRmORNvJn8npFTP1KzfuKecm/tYT0FobLR 9W7z61siKp9+kQ8kjF4c4cu7gltFqmpm5SDThQ1Sd5QjCyjHAcXLdEFdOuKUyhxN Z1+02LZv/IgKwiIOZRwL0ZaY95fB+G9wPObtMgPFwRfSJSVP7dEaxIj0Qbsf3qhh KyXk04R3yVMhfc//zCwb7sQjV0kWxdGakjcJdGI4dyNhgT+f7d1UVojAqL9lJm1j Ij4CnAUoRjnlN4ME36oF32fdz/bk2Pre2lVbrPDoC1VuuVqBoKzJLC298ZOoe8Jp kPyiCN+w9yg1VJ3xS0eo =EWVk -----END PGP SIGNATURE----- --4uYDHwxeWVfU+JOj--