Re: pgsql: Add relallfrozen to pg_class

On 2025-Mar-03, Melanie Plageman wrote:

> Add relallfrozen to pg_class
> 
> Add relallfrozen, an estimate of the number of pages marked all-frozen
> in the visibility map.
> 
> pg_class already has relallvisible, an estimate of the number of pages
> in the relation marked all-visible in the visibility map. This is used
> primarily for planning.
> 
> relallfrozen, together with relallvisible, is useful for estimating the
> outstanding number of all-visible but not all-frozen pages in the
> relation for the purposes of scheduling manual VACUUMs and tuning vacuum
> freeze parameters.

I'm confused about this.  Why was the new value added to pg_class
instead of to the pgstat system?  I don't think relallvisible is a good
precedent, because as you write here, that one is used for planning,
which has different requirements.  For vacuuming metrics we rely on
pgstat.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"El número de instalaciones de UNIX se ha elevado a 10,
y se espera que este número aumente" (UPM, 1972)