Re: monitoring usage count distribution - Mailing list pgsql-hackers

From Tom Lane
Subject Re: monitoring usage count distribution
Date
Msg-id 2020452.1680721630@sss.pgh.pa.us
Whole thread Raw
In response to Re: monitoring usage count distribution  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: monitoring usage count distribution
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Apr 5, 2023 at 1:51 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
>> The six-element array approach won't show the number of dirty and pinned
>> buffers for each usage count, but I'm not sure that's a deal-breaker.
>> Barring objections, I'll post an updated patch shortly with that approach.

> Right, well, I would personally be OK with 6 rows too, but I don't
> know what other people want.  I think either this or that is better
> than average.

Seems to me that six rows would be easier to aggregate manually.
An array column seems less SQL-ish and harder to manipulate.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Should vacuum process config file reload more often
Next
From: Andres Freund
Date:
Subject: Re: monitoring usage count distribution