Re: relfilenode statistics

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: relfilenode statistics
Date: 2026-07-11 03:44:24
Message-ID: alG8F9lVldB3WseN@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jul 10, 2026 at 09:09:39AM -0400, Andres Freund wrote:
> On 2026-07-10 15:05:35 +0900, Michael Paquier wrote:
>> 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?

Because I was under the impression that separating the counters first
made the implementation of the relfilenode stats and the recomputation
of them during WAL replay much cleaner, and after putting my hands on
it myself, well, I still do. 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.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2026-07-11 03:46:12 Re: BF mamba failure
Previous Message Henson Choi 2026-07-11 03:16:11 Re: Improve the performance of Unicode Normalization Forms.