Feedback-ID: i0fe9450f:Fastmail
Date: Mon, 17 Jun 2024 08:28:10 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: florisvannee@optiver.com, andres@anarazel.de,
	bertranddrouvot.pg@gmail.com, tgl@sss.pgh.pa.us,
	pgsql-bugs@lists.postgresql.org
Subject: Re: error "can only drop stats once" brings down database
Message-ID: <Zm91CpHheqXC_S_V@paquier.xyz>
References: <2cb577e176774caca28c724898768a38@Optiver.com>
 <ZmafJO3lpMjbyHXv@paquier.xyz>
 <e6a0bc8861b64acabce57c88e8e2c029@Optiver.com>
 <20240611.164457.1388765109177375375.horikyota.ntt@gmail.com>
 <ZmuQz8IN6MpLxKs8@paquier.xyz>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="8xjrggM8TCbVD1yd"
Content-Disposition: inline
In-Reply-To: <ZmuQz8IN6MpLxKs8@paquier.xyz>
Archived-At: 
 <https://www.postgresql.org/message-id/Zm91CpHheqXC_S_V%40paquier.xyz>
Precedence: bulk


--8xjrggM8TCbVD1yd
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Fri, Jun 14, 2024 at 09:37:35AM +0900, Michael Paquier wrote:
> I am wondering if we should tackle this problem by adding a notion of
> "age" in the stats entries for what's stored in the central dshash and
> in the hold copies in the backends, so as we dump the "age" of an
> existing stats entry if we find out that it gets reused in a create
> path.  That requires some design and would not be backpatchable, but
> it does not seem that invasive at quick glance (I had my eyes on this
> code the full week).  Other thoughts are welcome.

This still sounds like a good idea after sleeping on it over the
weekend.  Please note that I am moving on with the problem on this
thread where this has been reported, and that is the point of origin:
https://www.postgresql.org/message-id/ZmvVudpT8z6hbY9t@paquier.xyz

Let's continue the discussion there.
--
Michael

--8xjrggM8TCbVD1yd
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmZvdQoACgkQnvQgOdby
QH0TIRAApzmt5aqziV6s9RYrA89cpsUVFv8KuUNN3dfiES+3rZFN85CtlOITmwt7
L4u5/1IoymNQZRIerd5XUqgNu484pwUC0B5cgNeXl5op2966yoe6BWNeMQvKoXtW
k65Zgmc+o7Nxjw8RdysSCp2ZDiC8QNnZPtaUGohLvtSsaYMmehVl7VMXTJ2KjK58
8XFvEYMxTWA4WLOpxyvV1AWm+KsppoeVC1IJxRY8KPdLEaUbgMzuwNoWUTPtcAlP
cX44SI13YNje22AyGrpLRnuYNEw7RRAvN5trQH6m3TiEa7oCuQ9Rm1YgEyySgXjs
fN3CPG8wXzIb6u0PExskgceMHGE8V49FHzv1IZx0b1/G4fb39gPoQSo3ZCli8T03
NptX4l+DpzDsictZzAErxcH72U0qGbg53ow4azbxDXUM6hRiDlfNvCqafIhoTWP/
2fymfrAx+PvT3vDo1jX6YR/2ADbyLCFtx4iOoqnqe8HBrPn/O0Zc5+kaIwDs/FMa
vm6kgKHNbPBMTv3LgPjIfNzoOUUi24b8eUKPYB1zjoIYaIDBnTMSmprh1H64JrCW
JI7LxXacYRjKbdsvViKL6N3hwvbK579+K7lik0/jgd6gzx4GwRbKMdXDaLXcv2nx
C9V7V/Mj9/yYMnxLZsQ5Vo5lN/miOgE1kfiDVbo18E5YWm+FJqQ=
=liOL
-----END PGP SIGNATURE-----

--8xjrggM8TCbVD1yd--