Re: mxid_score can become Infinity in pg_stat_autovacuum_scores - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: mxid_score can become Infinity in pg_stat_autovacuum_scores
Date
Msg-id ajLI39rH9-I-PmMR@nathan
Whole thread
In response to Re: mxid_score can become Infinity in pg_stat_autovacuum_scores  (Sami Imseih <samimseih@gmail.com>)
Responses Re: mxid_score can become Infinity in pg_stat_autovacuum_scores
Re: mxid_score can become Infinity in pg_stat_autovacuum_scores
List pgsql-hackers
On Tue, Jun 16, 2026 at 11:21:57AM -0500, Sami Imseih wrote:
> I think this particular scenario is very clear to explain just like how
> we explain the failsafe scenario. Also, the suggested docs in the view
> link to the already existing detailed explanation of this behavior.
> 
> More generally, I think anytime there is a drastic change in a score,
> like jumping from a gradually ramping value around 1.x to suddenly
> hundreds of millions, that's something worth calling out in the docs.
> Users monitoring pg_stat_autovacuum_scores will notice that jump and want
> to understand why it happened.

Okay.  I fiddled with the patch a bit and came up with the attached.  WDYT?

-- 
nathan

Attachment

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: [PATCH] Improving index selection for logical replication apply with replica identity full
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Doc: document standard_conforming_strings dump/restore incompatibility