Re: What's The Difference Between VACUUM and VACUUM ANALYZE?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Дата
Msg-id 20070508215213.GC24167@alvh.no-ip.org
обсуждение исходный текст
Ответ на What's The Difference Between VACUUM and VACUUM ANALYZE?  ("Y Sidhu" <ysidhu@gmail.com>)
Ответы Re: What's The Difference Between VACUUM and VACUUM ANALYZE?  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Список pgsql-performance
Дерево обсуждения 
Y Sidhu escribió:
> I am trying to follow a message thread. One guy says we should be running
> vacuum analyze daily and the other says we should be running vacuum multiple
> times a day. I have tried looking for what a vacuum analyze is to help me
> understand but no luck.

VACUUM ANALYZE is like VACUUM, except that it also runs an ANALYZE
afterwards.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: david@lang.hm
Дата:
Сообщение: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?