Re: pgsql: Add relallfrozen to pg_class

2025-03-03 Thread Melanie Plageman
On Mon, Mar 3, 2025 at 11:44 AM Álvaro Herrera wrote: > > On 2025-Mar-03, Melanie Plageman wrote: > > > 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 V

Re: pgsql: Add relallfrozen to pg_class

2025-03-03 Thread Melanie Plageman
On Mon, Mar 3, 2025 at 11:48 AM Melanie Plageman wrote: > > On Mon, Mar 3, 2025 at 11:44 AM Álvaro Herrera > wrote: > > > > 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

Re: pgsql: Add relallfrozen to pg_class

2025-03-03 Thread Andres Freund
Hi, On 2025-03-03 17:44:54 +0100, Álvaro Herrera wrote: > 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

Re: pgsql: Add relallfrozen to pg_class

2025-03-03 Thread Álvaro Herrera
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 visibi