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 1wiWV8-000GCQ-1X for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Jul 2026 12:08:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wiWV6-003mfc-26 for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Jul 2026 12:08:09 +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 1wiWV6-003mfU-0w for pgsql-hackers@lists.postgresql.org; Sat, 11 Jul 2026 12:08:09 +0000 Received: from mail-wr1-x433.google.com ([2a00:1450:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wiWV5-00000000B5A-1j2z for pgsql-hackers@lists.postgresql.org; Sat, 11 Jul 2026 12:08:08 +0000 Received: by mail-wr1-x433.google.com with SMTP id ffacd0b85a97d-47122683cf3so967519f8f.0 for ; Sat, 11 Jul 2026 05:08:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1783771686; x=1784376486; 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=VWvTLeYq6SWPglXrES+ve+bhWSLI6lAcieF0HGeLwzM=; b=CFdNmN0tFZEI3lmKOHIUt68CjtYU4EUMCJocAAvLZUXKapwBhcJm3HFhxJEPun5Vt5 KhB0+M0de77c4zCo8Vs4dSmfj6GQ/mlEobIFhUsxj9o2d/csYU80OKYzmpJOyB8Px98+ w7LUATjwsFYUy5cNx7kqksMPpeOVExotpcbNDtWLAehBPhCh40nqs+IKgm0lawDQTv4B FnZO45izus4GOui7o/7CiM65P+ycfa9w4sqLLxsFXCVOK9eRXEuRClCakY6JN4zV5hGF Y0X15IEMSdJ4Ki1UDGa42tfGm8+soaTdCHEiJXyStWJzPeZ47vJO/KP/662pdFd2CYX/ iP9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783771686; x=1784376486; 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=VWvTLeYq6SWPglXrES+ve+bhWSLI6lAcieF0HGeLwzM=; b=rHuxQumiK86XXSypzjffunilsdTIZ2/7mnOmmj5l5AFrtt+oHMXK1lCJ68BHUYckHK BY6ungVoIApTR7W8Q2W7wuRnZWnFA0uSsQfFMOO84VVvdjZsj65It5mIW/kvAWsfjVTy uiGhDXxSVIX+sdPKjCFiYN2fI8gF4ALOySZbFngbS0ouut+4sqG+UF0OHkpKhdoUuyAx 1RQpGzg1+q9VWd/feOfsXzgBuzfAozYZ+PDSiBa1Pr3cXNfs/MKVVspseFcUuye677Qj r/sgS37Q0udAd4Hm5IULMBAKPI0GfNNGtTnp8zG34D5AI88pokO6tqOgcSmoa81VcCqa EHYw== X-Forwarded-Encrypted: i=1; AHgh+RqKxU5PA42Fr4GTIGBV8sUXoNaELwvbR26hz4eC6PEXyHoyFlDcKXiG3NgeUsRtzgTsdTK+nkqaeeVMfzSI@lists.postgresql.org X-Gm-Message-State: AOJu0YycLxB0FT8/H+xMNfJRmDmWqiLJiNTLz9h4TB9mT1SNiXgkY+mw IveQPZ0yvVhgGnvt2YWjcWinqE2rmGTeYxkWLjlA3+9IeWeKRPnYT48t X-Gm-Gg: AfdE7cnGh1tvo25+HuYDxnLAE5NIvFJekA+f+kbfvZ8xOsLrax2ogRELOB4zOCDflRL GKveZ5jUGkdU6xGggo3i7SYzzW3PcTR1EErjecdR9wB3WcUb90qAoLNskF84CrWiZFfM0oMn6Gd 64ykJSVoQqguY5a+//CM2kHbaeUJaLB3w67sZoPq8A4OtsVCd32gdew9IqtaHgzwRGxGm1TpaRf MfvkKVIk5ImDLhcwP39Q+b58U97ynQoTuEiMn/difGlzgGhz14seQgBivx3+ouKg6aFuYmfbN4v L43ivdDWo2E3AtD2SomlHSnFd8w4l9SL7TzMk8NxHo9esmPuKis/F7jHSxefDwDoG1mm28SF3Bl PozASi72+Ljk673F0V8gz8N3PEm2Mwvx+2HeH0Tay35QGtmo66G7WjybPyIkVwTRn7kKsEeTb8U UdA0s9fgImrIYIXrJXBpK19ATRLJq/cNzh/Z4dQ+YlviG9BYJbrZK3V1Y9JfVUkx7gtv4l4TbE X-Received: by 2002:a05:600c:3f07:b0:492:45a0:dcef with SMTP id 5b1f17b1804b1-493f87d9a4bmr23303105e9.5.1783771685484; Sat, 11 Jul 2026 05:08:05 -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-493eb6f16cfsm212897915e9.12.2026.07.11.05.08.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 11 Jul 2026 05:08:05 -0700 (PDT) Date: Sat, 11 Jul 2026 12:08:03 +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 On Sat, Jul 11, 2026 at 07:10:10PM +0900, Michael Paquier wrote: > On Sat, Jul 11, 2026 at 04:16:13AM +0000, Bertrand Drouvot wrote: > > 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 > > Honestly, I don't know which way is the best. I was just thinking that it could make more sense if you share your patches in the existing thread. But if you think that a new one is better, that's fine too. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com