Re: monitoring usage count distribution
Tom Lane <tgl@sss.pgh.pa.us>
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
Date: 2023-04-05T19:07:10Z
Lists: 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
Commits
-
Add pg_buffercache_usage_counts() to contrib/pg_buffercache.
- f3fa31327ecb 16.0 landed