Re: Is VACUUM ANALYZE a superset of VACUUM?

Поиск
Список
Период
Сортировка
От Dustin Sallings
Тема Re: Is VACUUM ANALYZE a superset of VACUUM?
Дата
Msg-id Pine.SGI.3.95.1001013161404.21383C-100000@bleu.west.spy.net
обсуждение исходный текст
Ответ на Is VACUUM ANALYZE a superset of VACUUM?  (Forest Wilkinson <fspam@home.com>)
Ответы Re: Is VACUUM ANALYZE a superset of VACUUM?
Список pgsql-general
On Fri, 13 Oct 2000, Forest Wilkinson wrote:

# Does running "VACUUM ANALYZE" incorporate the effects of a plain old
# "VACUUM"?  Or, must I run both "VACUUM" and "VACUUM ANALYZE" to have old
# rows removed *and* statistics gathered?  The docs aren't clear about
# this.

    I'm quite sure ``vacuum analyze'' does both.  Is there a reason
there's no ``analyze?''  I guess it doesn't make too much of a difference
without time travel.

--
SA, beyond.com           My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________


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