Re: Loss of data and info from system tables!!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Loss of data and info from system tables!!
Дата
Msg-id 2197.1112245752@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Loss of data and info from system tables!!  (Noel Faux <noel.faux@med.monash.edu.au>)
Ответы Re: Loss of data and info from system tables!!  (Noel Faux <noel.faux@med.monash.edu.au>)
Список pgsql-novice
Noel Faux <noel.faux@med.monash.edu.au> writes:
> We generally only vacuum
> tables which are affected by deletes, inserts and updates.

You can't do that as an exclusive practice :-(.  In particular I suppose
that you never vacuumed your system catalogs at all, and now you are
behind the eight ball because transaction IDs wrapped around.  See
http://www.postgresql.org/docs/7.4/static/maintenance.html#VACUUM-FOR-WRAPAROUND

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Loss of data and info from system tables!!
Следующее
От: Noel Faux
Дата:
Сообщение: Re: Loss of data and info from system tables!!