On Tue, Jan 11, 2022 at 9:20 PM Justin Pryzby <pry...@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
