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.96) (envelope-from ) id 1w5ZZL-003O0D-2G for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Mar 2026 01:31:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5ZZI-000SLv-2s for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Mar 2026 01:31:29 +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.96) (envelope-from ) id 1w5ZZI-000SLn-1x for pgsql-hackers@lists.postgresql.org; Thu, 26 Mar 2026 01:31:29 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w5ZZH-00000001411-07PR for pgsql-hackers@postgresql.org; Thu, 26 Mar 2026 01:31:27 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfout.stl.internal (Postfix) with ESMTP id 1F6FB1D001C0; Wed, 25 Mar 2026 21:31:26 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Wed, 25 Mar 2026 21:31:26 -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:subject :subject:to:to; s=fm1; t=1774488685; x=1774575085; bh=VR5+un4l11 T74ijsNVEUJJAvOEjllp1nPa5rV0eBwZE=; b=hUgSjeMjX89FGE58rfUSdfZBzh st/PXPZnifQDqFq7yKvcuXcLo5tszgKXLRagWYc2+FwK0vOTqZV6RzHiftPhGtXB J0dyIruTmfpIgjjRs+c1yiKyAcME+HLarOcfuH8qvwPAbZivtWVvYwVpkxNEhEIb imHaP/V62owfUHxWnWRgsEpbEt37no6KSCqbQ1DFKKstcx/6ykyi6HgYbuh8eStI tDyphnQkqMUJfEndiKDFjIR4yQVMp9III3pfikpXY6DE/vE/gowo91HAGzf1F2aC tJtLi2tPBuRN33er1Gd/5OVLXypYTAqQJltnM04R+Rj01n7qKeAzcdy3RNeA== 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:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1774488685; x=1774575085; bh=VR5+un4l11T74ijsNVEUJJAvOEjllp1nPa5 rV0eBwZE=; b=cJmiY0DQSgF3qD7VoBz9CovfEJk7JZL4lIh8npVUKS2BbRTj+s1 +8Mhk0mEIbyPyAC94EYpvdJ1LUzT3AFfGev8KZQ4DSR+0AvCFLAjOrQmzUp8hFvL nYIDSUqYy9UW0riZWUKHt0G7Zeyl8a+G1zM67j8osmQ/Gk8pES3XT0inCakoVD2X 6f2+2WCf1O9PwjCLJm5m2JiaVmUwhQQZuv0cBC2JaJ7UdgCmCjeIQXvCEEZtUiWI XHyP8q4pVmb9Wa18535zycHXkpSl2Wlzp/0E1ld1CLvTs6mdiMcU8C5SzXApJ0/o wLCRu33aqHlPMF6zVGMuGgGBG8o2eagSWqQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdefvdeitdegucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrh hlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeggeeg fffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidp nhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepnhgrgh grthgrsehsrhgrohhsshdrtghordhjphdprhgtphhtthhopehsrghmihhmshgvihhhsehg mhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtgh hrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 25 Mar 2026 21:31:23 -0400 (EDT) Date: Thu, 26 Mar 2026 10:31:19 +0900 From: Michael Paquier To: Yugo Nagata Cc: Sami Imseih , Pgsql Hackers Subject: Re: Track skipped tables during autovacuum and autoanalyze Message-ID: References: <20260324151133.7940a5c1f2ebd594d54da481@sraoss.co.jp> <20260325012847.e026ba1860c07288efe3e97d@sraoss.co.jp> <20260325132451.807ebb159f3b11e88ad4ecc0@sraoss.co.jp> <20260326101839.b186bdc5afc8d883c6a49262@sraoss.co.jp> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="EJZ6Z8FvrbzxE1r0" Content-Disposition: inline In-Reply-To: <20260326101839.b186bdc5afc8d883c6a49262@sraoss.co.jp> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --EJZ6Z8FvrbzxE1r0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Mar 26, 2026 at 10:18:39AM +0900, Yugo Nagata wrote: > I'm not sure this would significantly reduce the size of > PgStat_StatTabEntry. Could you elaborate on the expected benefits? The point is that this reduces the shmem footprint for indexes (well, it's also benefitial for tables, just less), on top of being cleaner because the stats views would only need to store and query the fields they care about for each relkind. -- Michael --EJZ6Z8FvrbzxE1r0 Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnEjGcACgkQnvQgOdby QH32Jw/+Lw1d3raNzZEMZ3UY2549UocA8ss6d17qZAzIc3MZJBu22cVM4xBUL0XV LQohvkV5g3DF+zyS1oUXBLIdRJ5qQqrkyAy1jf1dJK7HPK/kKMBfRWHJBktSewKT rJsaXJpRD4Il2OPgDGvpTI8HYITfCrRO2GhXiRdeOEswO4TWFlyv46T8zPhkl423 n8XId2TBVjxq/vYlelxrT+IwmV/9HMrQAMAuJokk4aU2cEXdly2qm2Ko2vAxEbHq lU52ZXbLIRDmPiJS2VX31u5inOnkahhsQgXnkPYeGN6MhX0fRUwZasJZ+Xuei2aO 2pWTJtGo6ml0GgqqNEZqHkDEmdUNolVtdI4c9zzTl3jgfdTPjuZP1dmYteKSjCx5 9JuJHG6S2w4V9NdZsfKV6qimU0bXX/WpiFAGETkUgiHttCiXR0KrNAJC3z7MZM4Q MoLscgbqPq9yZ8jrJpzoZjtCyCNwtV+Wb2yXST39cNg+PP1/dOV16RtnxYrikQnF ouCuG20jt3JSV93n1SwhBBt2OblemYalmcHp5kFDn7o1LIRinbFUgQYJKFGRkpMX VVl74Feow8mY3u0GHgimkGg6FbqwfZ2IdbfLk5OLPlGC7QQn4jGxlZEuPE//XayC llEv0ZyOooAkjCB8FxdXLcPIxz8PNupF84pRPd5/PXVJMWVqnhM= =0f2h -----END PGP SIGNATURE----- --EJZ6Z8FvrbzxE1r0--