With auto vacuum, is analyze still necessary?

Поиск
Список
Период
Сортировка
От Brendan Duddridge
Тема With auto vacuum, is analyze still necessary?
Дата
Msg-id 4B90D441-6599-4770-B928-E1E66B7F04A6@clickspace.com
обсуждение исходный текст
Ответ на SQL Question  (<operationsengineer1@yahoo.com>)
Ответы Re: With auto vacuum, is analyze still necessary?
Список pgsql-novice
Hello,

We're using PostgreSQL 8.1 on OS X Server. If we have auto vacuum
configured, does that mean we don't have to run analyze on our
tables? Does auto vacuum handle that for us? Or should we still
create a cron job to run analyze at a regularly scheduled interval?

Thanks,

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com

Вложения

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