| From: | John Naylor <john(dot)naylor(at)enterprisedb(dot)com> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(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>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: do only critical work during single-user vacuum? |
| Date: | 2022-01-12 15:09:49 |
| Message-ID: | CAFBsxsHiMar24Uf+86bi7PdK42bCZBNXz1tf2YBVuJEk9peFVg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jan 11, 2022 at 9:20 PM Justin Pryzby <pryzby(at)telsasoft(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2022-01-12 15:16:36 | Re: 2022-01 Commitfest |
| Previous Message | John Naylor | 2022-01-12 15:07:47 | Re: do only critical work during single-user vacuum? |