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 1wiP8W-000Bjx-0I for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Jul 2026 04:16:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wiP8U-002pa9-0j for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Jul 2026 04:16:18 +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 1wiP8T-002pa0-33 for pgsql-hackers@lists.postgresql.org; Sat, 11 Jul 2026 04:16:18 +0000 Received: from mail-wr1-x42e.google.com ([2a00:1450:4864:20::42e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wiP8R-00000000kuh-3PkN for pgsql-hackers@lists.postgresql.org; Sat, 11 Jul 2026 04:16:18 +0000 Received: by mail-wr1-x42e.google.com with SMTP id ffacd0b85a97d-47defd0c1c5so1032452f8f.3 for ; Fri, 10 Jul 2026 21:16:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1783743375; x=1784348175; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=7FHww91UTT4wLuWe6lmhh/LSeacmpjSziQahB1QbCwM=; b=ge5yKw0vBQmelJnwKojhIHczp+bFyxlDTvTLFLhfxzAJ9Pq9L+9WeBy+P3E9rZ8K2A owyK8p4sJ6qmtEvbIKV3oeBqVuysr5qIvCtHsS1bNBwFDpfSURmWHCl8UfJzBQQ9i1LE vSCiERaia1QTN32SsrV01vIOxctLfvW6WudFdLd7tI3Qq5KvAT/aDivU+MyhtYAJsfWP IVmNoMX7DtGK89JdbVF17+zpohL8xwsN0tP+/tMoZsEx84UXnZJD4/2hhAa5Wsmyx7yF RBy8OTxkFjkaAmVQEzknjd4MMF9VJ29ST5/TApaxYqMtVTUYJJgUljkHXI2G7sNkOlIW QPPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783743375; x=1784348175; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=7FHww91UTT4wLuWe6lmhh/LSeacmpjSziQahB1QbCwM=; b=nuv6MmTNP47LfrCpni+32TBQz9Z+OLr9JcCnbWSUBHwAkR5lG8h2STuIc+4u/4kXVA iGB4yspoW9aytNVKXtcWQzYRpH60K1JyZkvnGuxBxVgMi4SFqppZTk0S6F5k3wM0Mxxl mhZCg6nUoQFwT8GYU6uUCSjQ/5olRxWPRILBrkqXWS3i08Y6ADVzoHXYmJeJdWsLqLw3 /WvDkXX94OdEpFr11O7DanaiYFycRTwsqNYQX4OBdor6tXYiCocLDjRLkRrOJIWnPSLx wC7DrOQtYOtd2bhfpAXl+VRob671reg+wyswymbb5dxMhoU4l4ddp+vYAz6C3aJvzPZE vAOQ== X-Forwarded-Encrypted: i=1; AHgh+Rr8inSS32G3pKl2GWKaCl0S1BEOHQqnI0+Evn76qD2TdPG666aVtd3M+JE5jDH30dn+ZS53hGeVpk1oQjdH@lists.postgresql.org X-Gm-Message-State: AOJu0YxWXZ3nrB/dscjN0HDRc6H3xlIIkyDo9bd4EgSpR/K+FX27iQJS jp/KwTwIcGcyNrnW0KPu97iVV47lszXNQBDGTaUOnoo9xM4AVtHvKjBa X-Gm-Gg: AfdE7cmOfr4h2mTHtU1qKKIm88fMR5EGEcx+fK5AQXRHwpnUlIcPSGC6kYsFLTcBa0e F9LhjvS/bc3JSF+m1ezrMY9dOwWqDxNlR3+H1KBRBDA2Yax5KNtqXRoJx+iBXvDFgITrVrfI+Tt 8v4CNZ7SpbFaewguzrazFNjbBv93m6i+Fk0oWcDgQePImEpB9tNnyL8w4NLmmhZpSDJgt+jKdUW 9vlllcIWqxZdMjnvsVea5S53EUFO3qHqeqdXuv2edThfP8ZyaQexOxWgUx4/+WObl49G617yaeZ 1Hd2iy5BAHHZ0SYdprIrAlWB6RRfoUXqNGHYfEMBoWAgzaLcEx/zK23bnc2Kgayoym/IdQZMxz2 w8qwXgcLbI+PNovxWICoz8R6er8PcDjVYQ86Zo7RByt7retdso+866hECvBVlLQFMjUnMLvUqfC 6k1X85wLLdSunpcCjpJAqg7Znv4UBIxUSUkv6Y5tRqfkP7znVr9ZZQ+JDxI7sivNkLOVM9/Dw5 X-Received: by 2002:a05:600c:4ece:b0:493:a613:56b2 with SMTP id 5b1f17b1804b1-493f87d8573mr11268625e9.8.1783743375246; Fri, 10 Jul 2026 21:16:15 -0700 (PDT) Received: from bdtpg (ec2-15-237-197-144.eu-west-3.compute.amazonaws.com. [15.237.197.144]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-493eb6ea082sm199517365e9.11.2026.07.10.21.16.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 10 Jul 2026 21:16:14 -0700 (PDT) Date: Sat, 11 Jul 2026 04:16:13 +0000 From: Bertrand Drouvot To: Michael Paquier Cc: Andres Freund , Kirill Reshke , Robert Haas , pgsql-hackers@lists.postgresql.org Subject: Re: relfilenode statistics Message-ID: References: <74242uhjpufa2tsb6dqot7cvhhyxjbhfo273wpooo6hizbdg6o@f45d72gt2ujb> 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 Sat, Jul 11, 2026 at 12:44:24PM +0900, Michael Paquier wrote: > True enough that this deserves a thread > of its own, though. Will do so after cleaning up a few things in the > first two patches. Maybe resume this thread [1] instead of creating a new one? It's in this thread that it has been suggested to start with relfilenode stats first [2] but that was due to the design of the patch at that time that may not apply to yours (did not look at it yet). [1]: https://postgr.es/m/f572abe7-a1bb-e13b-48c7-2ca150546822%40gmail.com [2]: https://postgr.es/m/20230105002733.ealhzubjaiqis6ua%40awork3.anarazel.de Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com