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 1wiAzG-0003ND-2U for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Jul 2026 13:09:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wiAzD-000KtG-1q for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Jul 2026 13:09:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wiAzC-000Kt7-1h for pgsql-hackers@lists.postgresql.org; Fri, 10 Jul 2026 13:09:48 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wiAz9-00000000ehg-1PXl for pgsql-hackers@lists.postgresql.org; Fri, 10 Jul 2026 13:09:46 +0000 Received: from phl-compute-11.internal (phl-compute-11.internal [10.202.2.51]) by mailfout.stl.internal (Postfix) with ESMTP id 00C6C1D000FF; Fri, 10 Jul 2026 09:09:40 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-11.internal (MEProxy); Fri, 10 Jul 2026 09:09:41 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; 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=fm2; t=1783688980; x=1783775380; bh=DOQuAwbGhG v+wqbDvkmaKXdDTSuhgFbqLoFn6hIKJpk=; b=nBSarXaBEr30w3ZOTi8UwZ5bTX Pdb67pBb5PyBcBZ0PXGZCxuyNiD/rMw9IQZNqkmEwK3Ll6ahMnzfDBWYKiFJWTZC VyBcliMLQbmLDO6g2LRqwwIg0ykuU6DOSBSEMBcP44NM+5EKmcR7XvWsSpuHPtFJ yH1fI7mfwo0Na4h/ouqSzWA5mSM9qQjlDz5Lt8NsP4GPCatf307NL4CoyE16omtb X+F3S+OGZtUl7ewFAZo7BDaD6TQL9Pe+qIejTHrDAtgTtNYzcNFGRNZF/U+EwNRz zWYKF5SKF96uuJG1kInE0okeE9dc9Mo8EPcAzVNmv5QzOjLbiSOiqPt6O/5w== 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=fm2; t= 1783688980; x=1783775380; bh=DOQuAwbGhGv+wqbDvkmaKXdDTSuhgFbqLoF n6hIKJpk=; b=cAWrpgYI/e5iAPRhhozUgiwZ4Dke8tpIkSDfUK3hCqkX68giSkS qL52ziEeZK+agXKW3ZwqLmrkZInJOYVnXf5RPk6Kh+vuQg8VbbGhJz/3VJfGmYTr CdRTPPZLP589Unw//mrZJg9Dmbd9XFwIFA4DvY4WS1WfGVqwFJhLisaD4VFafb7B XBqLze6LIL4PFoNnnDt+6XW+ZR+ro3mNE/SZzr0I0pqxtoisLHqKIfa/yFJfGxUm 99IrFXd0XL9rLMUSK3bQ4c9s2DeozIXlI+zzk2Rhantl/Hb/xXG2uR1njWA3qOf5 ZjYda63yK3YUdsxhwRB+o3Tj06KPUn5wx5g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTE9cc4KaqRASuDK9bfTdIU8Z2NBcwv0Rsb7VNyYQoSjCDXBNiRr+sUS25GwXHWhrG whlSocyajYHzJBpdQHFTBWI8srbGMhwbHqqViZNC6DLHwnp7ftvczjC/YabQZkL0qHMRjz Jq13ZEVwLRmtQYP4S/ZkL+9pSgCB0rpYFZy9gaR+fw9rDWUlld3EeTga2smmIOwJYEr0An 4KykTMSkcwUA2icFHnK2WLPd3voGHG2Jn2n5Yl0Cs143e36b5S0RubN7ic3OB80WII5/BP ODfITLm9XGWdL6ZJULBXQDDaIRV1GIpO8lM0YWwN+Z8/6rd7w5RFmMXLS5/a9mtZOZaEXL jdRiWnTpIqPpZCUve1sThH4Dcah3Fv4abB2Luf49XK8/998Ao2JTPkZq6tTCWFvTJq1uUi RMpNciSkcRlIMqqyRJD44o5Okma7Lsg/Q8xgyBa2M8cu2RrKxmh9cwKaGab2taPaOzfUj1 1q4nWTqajmxI41HuGJWqP1i1EY1Pd5x52XAE/HyWaGK5zeRaxFs5XGrlvC+SvebhLM3R6C HFuQgzcLnDbheiysVXOpB1uFrSfXL1MuLepgfqFn0Da1HGAmUtAGnYiVKwXuJu3v4KQjOu vzoaaWtMROb42rK/gqS/UZowYOsFU0rjX87/MXzPPnZcB/1jyZy01QV4kvqw X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 10 Jul 2026 09:09:40 -0400 (EDT) Date: Fri, 10 Jul 2026 09:09:39 -0400 From: Andres Freund To: Michael Paquier Cc: Bertrand Drouvot , Kirill Reshke , Robert Haas , pgsql-hackers@lists.postgresql.org Subject: Re: relfilenode statistics Message-ID: <74242uhjpufa2tsb6dqot7cvhhyxjbhfo273wpooo6hizbdg6o@f45d72gt2ujb> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2026-07-10 15:05:35 +0900, Michael Paquier wrote: > On Mon, Mar 09, 2026 at 07:43:43AM +0000, Bertrand Drouvot wrote: > > PFA, a new mandatory rebase. > > So, we have discussed that a couple of days ago offline, and I still > felt uncomfortable to not do a cleanup of the relation stats data for > indexes. A lot of the fields are stored in memory and written in the > file, and remain unused for indexes. Why solve that as part of this thread / redesign, rather than as an orthogonal issue? Greetings, Andres Freund