Re: do only critical work during single-user vacuum?

On Tue, Jan 11, 2022 at 9:20 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
>
> On Tue, Jan 11, 2022 at 07:58:56PM -0500, John Naylor wrote:
> > +             // FIXME: also check reloption
> > +             // WIP: 95% is a starting point for discussion
> > +             if ((table_xid_age < autovacuum_freeze_max_age * 0.95) ||
> > +                     (table_mxid_age < autovacuum_multixact_freeze_max_age * 0.95))
> > +                     continue;
>
> Should be &&

Thanks! Will fix.

> Should this emergency vacuum "order by age() DESC" ?

That would add complexity and only save a marginal amount of time.

-- 
John Naylor
EDB: http://www.enterprisedb.com