Re: another autovacuum scheduling thread - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: another autovacuum scheduling thread
Date
Msg-id CAA5RZ0sZE-gfJ0c9HJkOk9XeFQwZL2wuJwrtOX+ZfUBLDcpFMA@mail.gmail.com
Whole thread
In response to Re: another autovacuum scheduling thread  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: another autovacuum scheduling thread
List pgsql-hackers
On Wed, Mar 11, 2026 at 12:08:52PM -0500, Sami Imseih wrote:
> The main issue is that the scores can reach quadrillions, or even billions,
> which feels excessive, especially if exposed in DEBUG3 or in a future
> prioritization view.

But why is that an issue?  Because the number looks big when there's
extremely verbose logging enabled?  I'm not following your objection. 

Yes, purely the looks of such an excessively large number could look wrong to a user. 
Putting on my user hat, I would be confused and honestly think this is a bug in the 
calculation. If we weren’t exposing the numbers, I would not care. 

But, this could just be me.

This comment "this component increases greatly once the age surpasses" is perhaps
good enough.

we _want_ the score to be excessively high in these cases so that there's
basically zero chance a table with unreasonable bloat takes priority.  This
was discussed a bit upthread [0].

[0] https://postgr.es/m/CAApHDvqrd%3DSHVUytdRj55OWnLH98Rvtzqam5zq2f4XKRZa7t9Q%40mail.gmail.com

Yes, I definitely agree with this. 

--
Sami Imseih
Amazon Web Services (AWS)

pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Defend against -ffast-math in meson builds
Next
From: Tom Lane
Date:
Subject: Re: Defend against -ffast-math in meson builds