pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Nathan Bossart <nathandbossart@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Cc: schneider@ardentperf.com
Subject: Re: monitoring usage count distribution
Date: Wed, 5 Apr 2023 12:41:01 -0700
Message-ID: <20230405194101.GB105962@nathanxps13> (raw)
In-Reply-To: <20230405190921.ck7v4y2h3ogoanvg@awork3.anarazel.de>
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>
	<20230405190921.ck7v4y2h3ogoanvg@awork3.anarazel.de>

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

view thread (20+ messages)  latest in thread

Message-ID: <20230405194101.GB105962@nathanxps13>
Permalink:  ../20230405194101.GB105962@nathanxps13/
Also on:    postgresql.org/message-id/20230405194101.GB105962@nathanxps13

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, andres@anarazel.de, robertmhaas@gmail.com, schneider@ardentperf.com
  Subject: Re: monitoring usage count distribution
  In-Reply-To: <20230405194101.GB105962@nathanxps13>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox