VACUUM vs VACUUM ANALYZE

Поиск
Список
Период
Сортировка
От Mark Coffman
Тема VACUUM vs VACUUM ANALYZE
Дата
Msg-id 00a101c15803$63b9ed40$91010a0a@npinfocorp.com
обсуждение исходный текст
Ответ на Re: To Postgres Devs : Wouldn't changing the select limit  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: VACUUM vs VACUUM ANALYZE
Re: VACUUM vs VACUUM ANALYZE
Список pgsql-general
I know the differences between VACUUM and VACUUM ANALYZE have been discussed
before, but I'd like to know how you schedule your cleaning jobs.  Right now
I do a

VACUUM
VACUUM ANALYZE

every hour... it takes about 3 minutes to run both.  Should I run ANALYZE
less often?

Mark
Epilogue.net


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