Re: BUG #5067: vacuum problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5067: vacuum problem
Дата
Msg-id 11225.1253403181@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5067: vacuum problem  ("Pasquale" <pasquale.napolitano@gmail.com>)
Список pgsql-bugs
"Pasquale" <pasquale.napolitano@gmail.com> writes:
> I don't connect any more to postres db because postgres needs to vacuum
> operation.
> Then, i use a standalone backend to connect to postgres db.
> Now i'm im in backend> and i write VACUUM FULL.

You don't really need VACUUM FULL, only VACUUM.

> I have this message:

> WARNING: database "postgres" must be vacuumed within 999455 transactions
> HINT: To avoid a database shutdown, execute a full-database VACUUM in
> "postgres".
>   999453

It's not an error, only a warning.  You'll get a couple of those for
each table in the VACUUM, but after you finish it should stop complaining.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: notice on explicit primary key or index name
Следующее
От: "Paulo"
Дата:
Сообщение: BUG #5068: LIKE