MIME-Version: 1.0
References: <ZlGYokUIlERemvpB@ip-10-97-1-34.eu-west-3.compute.internal>
 <Zo4j-mC0Ps3vnjZ4@paquier.xyz> <Zo6OvsBLUbYm6nQM@ip-10-97-1-34.eu-west-3.compute.internal>
 <Zo9j69GhexDpeV4k@paquier.xyz> <Zo93T63yVkDcKw3P@ip-10-97-1-34.eu-west-3.compute.internal>
 <ZrBi9vNj5Ntyu62U@ip-10-97-1-34.eu-west-3.compute.internal>
 <Ztk4JIgWKk/8/dmd@ip-10-97-1-34.eu-west-3.compute.internal>
 <Zt/ZeIeWq0UVSAuy@ip-10-97-1-34.eu-west-3.compute.internal>
 <ZyiTiqWPbRMseQjb@ip-10-97-1-34.eu-west-3.compute.internal>
 <CA+TgmoZtRxvAuMyO4bQjj5t47XWvQsowPAedkOkrCP61B7mQFg@mail.gmail.com> <Zym1xlMhuzPdekMt@ip-10-97-1-34.eu-west-3.compute.internal>
In-Reply-To: <Zym1xlMhuzPdekMt@ip-10-97-1-34.eu-west-3.compute.internal>
From: Kirill Reshke <reshkekirill@gmail.com>
Date: Fri, 29 Nov 2024 11:23:12 +0500
Message-ID: <CALdSSPhQyvK_wsvV+HiQcC6f57Zg2WO60wxv=CXbcoZ1p5HHEQ@mail.gmail.com>
Subject: Re: relfilenode statistics
To: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Michael Paquier <michael@paquier.xyz>, 
	pgsql-hackers@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CALdSSPhQyvK_wsvV%2BHiQcC6f57Zg2WO60wxv%3DCXbcoZ1p5HHEQ%40mail.gmail.com>
Precedence: bulk

On Tue, 5 Nov 2024 at 11:06, Bertrand Drouvot
<bertranddrouvot.pg@gmail.com> wrote:
>
>
> Does it sound ok to you to move with the above principal? (I'm +1 on it).
>

Hi! I looked through this thread.
Looks like we are still awaiting a patch which stores more counters
(n_dead_tup, ... etc) into relfilenode stats. So, I assume this should
be moved to the next CF.

I also have a very stupid question:
If we don=E2=80=99t have the relation OID when writing buffers out, can we
just store oid to buffertag mapping somewhere and use it?
I suspect that this is a horrible idea, but what's the exact reason?
Is it that we will break too many abstraction layers for such a minor
matter?

--=20
Best regards,
Kirill Reshke