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

[Torsten Förtsch <torsten.foertsch@xxxxxxx>]

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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general