Re: With auto vacuum, is analyze still necessary?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: With auto vacuum, is analyze still necessary?
Дата
Msg-id 29659.1136906378@sss.pgh.pa.us
обсуждение исходный текст
Ответ на With auto vacuum, is analyze still necessary?  (Brendan Duddridge <brendan@clickspace.com>)
Список pgsql-novice
Дерево обсуждения 
Brendan Duddridge <brendan@clickspace.com> writes:
> 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?

Yes, though you might wish to twiddle its settings for how often to
do it.

            regards, tom lane

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: translating this SQL query from a different dialect
Следующее
От: "Lane Van Ingen"
Дата:
Сообщение: Error Returned by A Function