Is it possible to avoid the VACUUM FREEZE when upgrading to 9.3.2? - Mailing list pgsql-general

From Torsten Förtsch
Subject Is it possible to avoid the VACUUM FREEZE when upgrading to 9.3.2?
Date
Msg-id 52A31908.9010002@gmx.net
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Eliott
Date:
Subject: Constantly increasing per connection memory usage on pg 9.2
Next
From: Jeff Janes
Date:
Subject: Re: Constantly increasing per connection memory usage on pg 9.2