Re: monitoring usage count distribution

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: monitoring usage count distribution
Дата
Msg-id 2020452.1680721630@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: monitoring usage count distribution  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: monitoring usage count distribution  (Nathan Bossart <nathandbossart@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Should vacuum process config file reload more often
Следующее
От: Andres Freund
Дата:
Сообщение: Re: monitoring usage count distribution