Re: Warning about using pg_stat_reset() and pg_stat_reset_shared()

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Warning about using pg_stat_reset() and pg_stat_reset_shared()
Date: 2022-10-17 19:07:20
Message-ID: Y02n6BDWi/gj4Bw9@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 12, 2022 at 12:04:08PM -0400, Bruce Momjian wrote:
> > Maybe the random sample taken by ANALYZE for your case didn't happen
> > to land on any pages with dead tuples?
>
> Ah, good point, I missed that in pgstat_report_analyze(). I will apply
> the patch then in a few days, thanks.

Patch applied back to PG 10, thanks.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Indecision is a decision. Inaction is an action. Mark Batterson

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2022-10-17 20:09:21 Re: pub/sub - specifying optional parameters without values.
Previous Message Robert Haas 2022-10-17 18:56:23 Re: Eliminating SPI from RI triggers - take 2