Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hS94K-00036f-B5 for pgsql-hackers@arkaria.postgresql.org; Sat, 18 May 2019 23:48:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hS94J-0001vk-3j for pgsql-hackers@arkaria.postgresql.org; Sat, 18 May 2019 23:48:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hS94I-0001kq-Kq for pgsql-hackers@lists.postgresql.org; Sat, 18 May 2019 23:48:46 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hS94F-00085Q-S1 for pgsql-hackers@postgresql.org; Sat, 18 May 2019 23:48:45 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id B3B745F79F; Sat, 18 May 2019 19:48:41 -0400 (EDT) Date: Sat, 18 May 2019 19:48:41 -0400 From: Stephen Frost To: Tom Lane Cc: Tomas Vondra , Andres Freund , Dean Rasheed , PostgreSQL Hackers Subject: Re: Multivariate MCV stats can leak data to unprivileged users Message-ID: <20190518234841.GE6197@tamriel.snowman.net> References: <20190517202938.lkx6q2u6woiptrsa@alap3.anarazel.de> <21269.1558192388@sss.pgh.pa.us> <4E0E0C14-C476-446A-835F-CC3558709DA9@anarazel.de> <20190518190042.2y33h4toxk4fxv5t@development> <568.1558208711@sss.pgh.pa.us> <20190518232812.qpnjmydlx3uzzsj7@development> <20866.1558223060@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="qjsCQguEqePwFT+e" Content-Disposition: inline In-Reply-To: <20866.1558223060@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: Precedence: bulk --qjsCQguEqePwFT+e Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Tom Lane (tgl@sss.pgh.pa.us) wrote: > Tomas Vondra writes: > > On Sat, May 18, 2019 at 03:45:11PM -0400, Tom Lane wrote: > >> Tomas Vondra writes: > >>> But that's not an issue intruduced by PG12, it works like that even f= or > >>> the extended statistics introduced in PG10. >=20 > >> Yeah, but no time like the present to fix it if it's wrong ... >=20 > > Sorry, not sure I understand. Are you saying we should try to rework > > this before the beta1 release, or that we don't have time to do that? >=20 > > I think we have four options - rework it before beta1, rework it after > > beta1, rework it in PG13 and leave it as it is now. >=20 > Yup, that's about what the options are. I'm just voting against > "change it in v13". If we're going to change it, then the fewer > major versions that have the bogus definition the better --- and > since we're changing that catalog in v12 anyway, users will see > fewer distinct behaviors if we do this change too. >=20 > It's very possibly too late to get it done before beta1, > unfortunately. But as Andres noted, post-beta1 catversion > bumps are hardly unusual, so I do not think "rework after > beta1" is unacceptable. Agreed. Thanks, Stephen --qjsCQguEqePwFT+e Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJc4JnZAAoJEO1sijiDR2RV9h8P/RQf3mZ7lavcMWGzmEt3hbCT 9o5+AXa+Ekz/tDuZYv06jsn1QjvrVXN6fqZyobyG3zBpIO6VsKgQzFf8s9HoiNGq brHWxZJnne/gbhys/8rS+kM2P7MyIaYYCo1tplYOsXqBAPprZ0lenTYkKfKPXsjL TT5RB7ZrG64dctt9QklPvn0OPOZWmApweaP74xzLADj5pt1we+8X65OvMIMQvxrI +OlnN0J9x6zSdtC2NHc1iY9vP9gOUXRYf1GA2ZiBe7diuGqmH6SVWbLPUh3q9ghp z2oindIvoEnUU/zlxBDoYhhL/szXWV2pbaJ2cA7rPSc4hdROqnvNjrf4yZPgBmCk IpOWmHrZC9SAAJ7fseAaw2zL/ep0iXsZ65uc9g+NpBGL0k9ZJ4HAhoXeXc1qVXrp hoskAUMkAAzSG+69mnI7/L42rAz2QQGu6PnBLHgTwV+GmU4//VbgSau73m94DcOl ozOraX27Ccz/aoMSD1pQjPyr5X5wtYXq7pAGS9x27rD8Brc2x4WkoD2LYbkZb+Lz Uq7hjBqQ79IDwHUMOWRRR+dJQ9PizXRWwzObirsTu5GIuPRWkvYP9K1dBZllz4cF 55oXU5O1/+YAG1pbaEJhFXLgI3sK4Mqmzp/GEkFRaTDm+Fb4dZVH2YI9kICVC1FF WoJzNIXICtumRtUKi6EP =yJrV -----END PGP SIGNATURE----- --qjsCQguEqePwFT+e--