Re: BUG #1333: vacuum full apparently fails to complete

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1333: vacuum full apparently fails to complete
Дата
Msg-id 21194.1101832823@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1333: vacuum full apparently fails to complete  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Список pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> At this point, the vacuum is *still* in progress (after 8 hours) and disc
> activity is exclusively the result of this vacuum, about 140 blocks/second
> with no disc queues. Is this likely to be a bug or just a scalability issue
> involving vacuum and the large object table?

vacuum full can take an awfully long time.  It might be worth your while
to try a CLUSTER instead.

            regards, tom lane

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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Bug: 8.0.0b5 Win Server Installer
Следующее
От: "Stephan Heilner"
Дата:
Сообщение: service doesn't start