Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qUcPy-00DXJt-Cr for pgsql-bugs@arkaria.postgresql.org; Sat, 12 Aug 2023 00:23:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qUcPw-00Csd1-Kz for pgsql-bugs@arkaria.postgresql.org; Sat, 12 Aug 2023 00:23:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qUcPw-00Csct-Co for pgsql-bugs@lists.postgresql.org; Sat, 12 Aug 2023 00:23:44 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qUcPu-001slM-Fk for pgsql-bugs@lists.postgresql.org; Sat, 12 Aug 2023 00:23:43 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 9F9C43200786; Fri, 11 Aug 2023 20:23:40 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Fri, 11 Aug 2023 20:23:41 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1691799820; x=1691886220; bh=Lc g8A2AzP9HMlE0WBvJFyipFRaf1JVSr5j2tpBy1Le4=; b=sAm1/Rg+WZVModbAej fhTmmXAhBqoYFETtGLK0LkoCLVRLhGQeK2P9hNHxtPFDAsjuJfT4DPwRb7MMLWgC 7adUN95hhFWSJF+vUF+OGO/KodVHicsBzqTeZOCEKI2yOa9HQKhUFN49tIOkStH8 K5Wq306cRHa41Q8qHz866V7j+PBFcTkYnhVRb1Zv7h0u2sgG8r6VhCBzqJ1zxYhC 2qXNRXcAWou92VsDvwRi5sb2JewTyhe3vU9tROMQHE0lXJ57EVjZnmUTZ50dw3Se KajFeJj+Xsvjga7tCGmf6VgswptpdbLo2gj3ZGnUARl2JhFzOhpMpdHsWUl9I5Y8 0wJg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1691799820; x=1691886220; bh=Lcg8A2AzP9HMl E0WBvJFyipFRaf1JVSr5j2tpBy1Le4=; b=zg9fS09CXxGkJC7K3e5PZRSoyoWV/ +2CeMccVkvNei5Imxcp/l+voLjIuvYDi6+Lk71QNsVuv/lbHxpp0AQX9HM8b05MW 4DV+f3yiGXdHgnjBJQqaDUPMEdvsPXh2urfS7aKBxQ7UFvgY6MUTs9V6yT6NmQvZ LCfTy7wx3csBHSSWIWKMYTSEgnSEEEOgahoQusQg9x0lZKdODRA4u4nwDY0EHBOZ oFnpMdUEFdEs0z9u5iHy96I6lm+/9XPKuR3LSabzVNCia9AIC+PA7AvCj4U8W5Nt /xvpI/HmSY1yM7Rx/i1guXxlOZVW7AR3SIwU4AveBEES9Dd+icFqgcROQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrleelgdeffecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtroertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeffudelheeghfekfefgfedthfek uddtvdfhudekgeegheeikefflefhleekheetfeenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 11 Aug 2023 20:23:38 -0400 (EDT) Date: Sat, 12 Aug 2023 09:23:35 +0900 From: Michael Paquier To: Jacob Speidel Cc: Will Mortensen , Andres Freund , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Message-ID: References: <17973-bca1f7d5c14f601e@postgresql.org> <20230614213724.gweo666oxqrugm44@awork3.anarazel.de> <20230614215744.ddeuii7jcojbp3yv@awork3.anarazel.de> <20230614223012.cfyzxyfnt3ggqkt4@awork3.anarazel.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="LjWYRY4nCGFqUyXq" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --LjWYRY4nCGFqUyXq Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Aug 11, 2023 at 02:15:34PM -0700, Jacob Speidel wrote: > I don't think this is a surprise to anyone but this is just an update that > the bug still exists in 15.4 and the patch from Andres still fixes the > problem. Yes, this one has been sitting in my inbox for a few weeks now. The part I am not quite sure of is what we should do for the stats gathered by startup process, but that's separate from this autovacuum scheduling problem at the end. Andres, were you planning to do something here or did you need some help? -- Michael --LjWYRY4nCGFqUyXq Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmTW0QcACgkQnvQgOdby QH3URhAAl8wYDnTJz6aJlMwZq+CNuBInkHyuuVK35S1RmjiUgnMsHN6dVUvewgKk TZue+qBcOU+XgmoocR0KPhO2xgMVboJyJUlsMvcGU8nYnx2Qhz6TfjFdK9jfxKxL NJsD7uQRjEgDIuo9zFbwWMGPqTADVB1nvI0phqziRFyGIU4imWgEb5IVCce+OKGR Y79mI7Cdk2+Fk/blI4C13rY3A0dyqDcci5u8EsN9ODtCPg3qwq+4ERE2g8Hwe6M6 uFyxEnPQNOdBIIoffernNo8DaxyoODKeqnBYhwFcq6p4fb1COJ7bCijniSpbDxGG e4dwn5yOQ6R322YOBatERcYf7jN7qMaaDzavl/A1JlFrMWoA+kj28gr7s+yjc0Kz +a3h07/lUU60EhJ1h2zaxPATyYv+pQ6iQ7LrI4P185F4QvUhp32x3W3l3U9Z4ieD mJ645v9sIderUWfszFMaJjv+bhMKXAIaZ9Gj8iwBkga+FkdrreNmvYrJfw1CQE5a ArOUuHDvWxmtUKGxAzTIVum3i1wuUz+/RyHyEeSRmifzGLkSCISmcunTrmRoFv2R JFNfTrhgQ6xaMKuWAJG4by4yQ+NVWbawUQmDvhitPZ5pn4O4v0kPMhaWrjNN2d/7 2zVIoi/gQc4pp6x4fjnRbmj9/ORGCRt+dcMFMBPRe9bdIWjZ9gY= =IQ36 -----END PGP SIGNATURE----- --LjWYRY4nCGFqUyXq--