Thread: Is it possible to avoid the VACUUM FREEZE when upgrading to 9.3.2?

Is it possible to avoid the VACUUM FREEZE when upgrading to 9.3.2?

From
Torsten Förtsch
Date:
Hi,

can the VACUUM FREEZE be skipped if

a) txid_current < vacuum_freeze_min_age or if

b) txid_current < vacuum_freeze_table_age or if

c) txid_current < autovacuum_freeze_max_age and no manual VACUUM has
been done?

Or is the operation perhaps only necessary for tables matching

 select n.nspname, c.relname, c.relfrozenxid
   from pg_class c join pg_namespace n on c.relnamespace=n.oid
  where c.relfrozenxid::text::int>=(select setting::int
                                      from pg_settings
                                     where name='vacuum_freeze_min_age')

or similar?

Thanks,
Torsten