Re: indexes are farked

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: indexes are farked
Дата
Msg-id 1124723864.26477.0.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: indexes are farked  (Neil Conway <neilc@samurai.com>)
Список pgsql-general
Дерево обсуждения 
On Mon, 2005-08-08 at 15:30, Neil Conway wrote:
> Scott Marlowe wrote:
> > You might want to schedule analyzes to run every thirty minutes or every
> > hour.
>
> I doubt that is necessary or wise. Rerunning ANALYZE should only be
> necessary when the distribution of your data changes significantly --
> e.g. after a bulk load or deletion of a lot of content. IMHO In most
> circumstances, running ANALYZE once a day is more than sufficient.


I just let pg_autovacuum decide for me.  Really is easier than doing it
yourself.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: http://www.postgresql.org/docs/8.0/static/xfunc-sql.html
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question about expressions with raise plpgsql statement in coming 8.1