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?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: SQL Question
Следующее
От: Joao Miguel Ferreira
Дата:
Сообщение: Preventing access of user1 to user2's database