Re: Performace Optimization for Dummies

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема Re: Performace Optimization for Dummies
Дата
Msg-id efi9bo$2aja$1@news.hub.org
обсуждение исходный текст
Ответ на Performace Optimization for Dummies  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Ответы Re: Performace Optimization for Dummies  (Markus Schaber <schabi@logix-tt.com>)
Re: Performace Optimization for Dummies  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-performance
>> indexes. I don't know whether autovacuum will also analyze tables
>> for you automagically, but it would be a good idea to analyze the table
>
> It does.

So, I have checked my log and I see an autovacuum running once every minute
on our various databases being hosted on the server - once every minute!

From what I can see, autovacuum is hitting the db's in question about once
every five minutes. Does this imply an ANALYZE is being done automatically
that would meet the requirements we are talking about here? Is there any
benefit ot explicitly performing an ANALYZE?

(Or does this go hand-in-and with turning off autovacuum...?)



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performace Optimization for Dummies
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Performace Optimization for Dummies