Re: [WIP] Add relminxid column to pg_class

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [WIP] Add relminxid column to pg_class
Date: 2006-04-10 04:04:58
Message-ID: 16247.1144641898@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> What do you think of making vacuum a no-op on a table that has datminxid
> = FrozenXid?

I think this is probably OK for plain VACUUM and VACUUM FREEZE, but not
for VACUUM FULL, since a frozen table isn't necessarily fully packed.

Also, for VACUUM ANALYZE, the ANALYZE step is likely still needed?

regards, tom lane

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Qingqing Zhou 2006-04-10 08:38:06 Re: Support Parallel Query Execution in Executor
Previous Message Alvaro Herrera 2006-04-10 03:57:11 Re: [WIP] Add relminxid column to pg_class