Re: Is VACUUM ANALYZE a superset of VACUUM?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is VACUUM ANALYZE a superset of VACUUM?
Дата
Msg-id 1748.971499189@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Is VACUUM ANALYZE a superset of VACUUM?  (Dustin Sallings <dustin@spy.net>)
Список pgsql-general
Dustin Sallings <dustin@spy.net> writes:
>     I'm quite sure ``vacuum analyze'' does both.

Correct.

> Is there a reason there's no ``analyze?''

Historical, mostly.  No essential reason I can think of.  In current
sources the "analyze" part is run as a separate read-only transaction
after the data-compaction "vacuum" part, so they're at arm's length
already.  But no one's got round to building a separate statement.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: config
Следующее
От: Philip Warner
Дата:
Сообщение: Re: Question about pg_dump