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

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: do only critical work during single-user vacuum?
Date: 2022-01-12 02:20:27
Message-ID: 20220112022026.GC14051@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 &&

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

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2022-01-12 03:21:24 Re: Skipping logical replication transactions on subscriber side
Previous Message Julien Rouhaud 2022-01-12 02:18:11 Re: Can there ever be out of sequence WAL files?