Re: VACUUM FULL cannot be VERBOSE?

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: VACUUM FULL cannot be VERBOSE?
Дата
Msg-id BANLkTi=bAf3xk_uc-L67sJa5tFM3EK0wdg@mail.gmail.com
обсуждение исходный текст
Ответ на VACUUM FULL cannot be VERBOSE?  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
Список pgsql-general
2011/6/30 Miroslav Šulc <miroslav.sulc@startnet.cz>:
> is it correct behavior that when i issue command "VACUUM VERBOSE", i get
> output with DETAIL info, but when i issue "VACUUM FULL VERBOSE", no
> details are displayed?

Yes, this seems OK. PostgreSQL 9.0 has a new implementation of VACUUM
FULL, which behaves more like CLUSTER. This new implementation doesn't
account statistics like a normal VACUUM VERBOSE does.

It seems that PostgreSQL 9.1 re-adds these stats to VACUUM FULL VERBOSE.

Regards,
Marti

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Contrib source
Следующее
От: Dmitry Koterov
Дата:
Сообщение: How to create "auto-increment" field WITHOUT a sequence object?