What's The Difference Between VACUUM and VACUUM ANALYZE?

Поиск
Список
Период
Сортировка
От Y Sidhu
Тема What's The Difference Between VACUUM and VACUUM ANALYZE?
Дата
Msg-id b09064f30705081443w25bf2e6o3a663c5f3a2a7798@mail.gmail.com
обсуждение исходный текст
Ответы Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Список pgsql-performance
Дерево обсуждения
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.

--
Yudhvir Singh Sidhu
408 375 3134 cell

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

Предыдущее
От: Mark Lewis
Дата:
Сообщение: Re: Throttling PostgreSQL's CPU usage
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: [PERFORM] specific query (not all) on Pg8 MUCH slower than Pg7