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)
