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

Поиск
Список
Период
Сортировка
От Torsten Förtsch
Тема Is it possible to avoid the VACUUM FREEZE when upgrading to 9.3.2?
Дата
Msg-id 52A31908.9010002@gmx.net
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Eliott
Дата:
Сообщение: Constantly increasing per connection memory usage on pg 9.2
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Constantly increasing per connection memory usage on pg 9.2