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

From Nathan Bossart
Subject Re: monitoring usage count distribution
Date
Msg-id 20230405194101.GB105962@nathanxps13
Whole thread Raw
In response to Re: monitoring usage count distribution  (Andres Freund <andres@anarazel.de>)
Responses Re: monitoring usage count distribution  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Apr 05, 2023 at 12:09:21PM -0700, Andres Freund wrote:
> I would not mind having a separate function returning 6 rows, if we really
> want that, but making pg_buffercache_summary() return 6 rows would imo make it
> less useful for getting a quick overview. At least I am not that quick summing
> up multple rows, just to get a quick overview over the number of dirty rows.

This is what v1-0001 does.  We could probably make pg_buffercache_summary a
view on pg_buffercache_usage_counts, too, but that doesn't strike me as
tremendously important.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: monitoring usage count distribution
Next
From: Robert Haas
Date:
Subject: Re: Should vacuum process config file reload more often