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

From: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Is it possible to avoid the VACUUM FREEZE when upgrading to 9.3.2?
Date: 2013-12-07 12:48:08
Message-ID: 52A31908.9010002@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-12-07 20:53:44 Re: Constantly increasing per connection memory usage on pg 9.2
Previous Message Eliott 2013-12-07 09:10:27 Constantly increasing per connection memory usage on pg 9.2