From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
cc: Nathan Bossart <nathandbossart@gmail.com>,
        Andres Freund <andres@anarazel.de>, pgsql-hackers@postgresql.org,
        schneider@ardentperf.com
Subject: Re: monitoring usage count distribution
In-reply-to: 
 <CA+TgmoYRHDDJTgPcFkomz4KzzsQHXRJtqKeJyOk4AZNTjf=TnQ@mail.gmail.com>
References: <20230130233040.GA2800702@nathanxps13>
 <CA+Tgmoa-c3avHFBdko9d7bGQuYXrJhHHjhG1yAs8h-k_sLbyPQ@mail.gmail.com>
 <20230404232919.uibzbhjdylk3mlvp@awork3.anarazel.de>
 <CA+TgmobrQ90KGN4dwxL8q-LV529gCMmzXiy8CG5eQwjYTPzZLA@mail.gmail.com>
 <20230405175124.GA31516@nathanxps13>
 <CA+TgmoYRHDDJTgPcFkomz4KzzsQHXRJtqKeJyOk4AZNTjf=TnQ@mail.gmail.com>
Comments: In-reply-to Robert Haas <robertmhaas@gmail.com>
	message dated "Wed, 05 Apr 2023 15:00:20 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2020451.1680721630.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 05 Apr 2023 15:07:10 -0400
Message-ID: <2020452.1680721630@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2020452.1680721630%40sss.pgh.pa.us>
Precedence: bulk

Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Apr 5, 2023 at 1:51=E2=80=AFPM Nathan Bossart <nathandbossart@gm=
ail.com> wrote:
>> The six-element array approach won't show the number of dirty and pinne=
d
>> 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 approa=
ch.

> 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