Re: Vacuum analyze in 7.1.1

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: Vacuum analyze in 7.1.1
Дата
Msg-id
Pine.LNX.4.30.0106132237130.756-100000@peter.localdomain
Ответ на
Список
Дерево обсуждения
Re: Vacuum analyze in 7.1.1 "David Wall" <d.wall@computer.org>
David Wall writes:

> Does a 'vacuum analyze' do the same functions as a plain 'vacuum' PLUS the stats updates?  Just wondering if I need to run both commands from time to time, or if I can just do 'vacuum analyze'?  I'm running 7.1.1 now.

yes / no / yes

However, depending on your application you might want to run 'vacuum' more
often than 'vacuum analyze'.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

В списке pgsql-general по дате отправления
От: Peter Eisentraut
Дата:
От: Lamar Owen
Дата:
FAQ