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

Started by Torsten Förtschover 12 years ago1 messagesgeneral
Jump to latest
#1Torsten Förtsch
torsten.foertsch@gmx.net

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general