Re: some databases have not been vacuumed ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: some databases have not been vacuumed ...
Дата
Msg-id 11914.1123002489@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: some databases have not been vacuumed ...  (Christopher Browne <cbbrowne@acm.org>)
Список pgsql-admin
Christopher Browne <cbbrowne@acm.org> writes:
> The problem is likely that the "old tuples" are in some database not
> being vacuumed.  template1 is a likely candidate; do a plain VACUUM on
> that and the message may go away.

It's not really necessary to guess about which database(s) are
triggering the message: a quick look in pg_database will tell you.
See TFM:
http://www.postgresql.org/docs/8.0/static/maintenance.html#VACUUM-FOR-WRAPAROUND

            regards, tom lane

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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: some databases have not been vacuumed ...
Следующее
От: Brock Williams
Дата:
Сообщение: FATAL: cache lookup failed for access method 6881280