Re: About autovacuum

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: About autovacuum
Дата
Msg-id 20070904150102.6441483b.wmoran@collaborativefusion.com
обсуждение исходный текст
Ответ на About autovacuum  (Jean-David Beyer <jeandavid8@verizon.net>)
Список pgsql-performance
In response to Jean-David Beyer <jeandavid8@verizon.net>:

> I have this turned on, and if I look at the log, it runs once a minute,
> which is fine.
>
> But what does it do? I.e, it runs VACUUM, but does it also do an analyze?

Yes.  If you turn up the debugging level, you'll see detailed log
messages about its activities.

There were discussions on other lists about improving autovacuum's log
messages, I'm pretty sure it will log more helpful information in 8.3.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

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

Предыдущее
От: "Walter Mauritz"
Дата:
Сообщение: join tables vs. denormalization by trigger
Следующее
От: Mark Lewis
Дата:
Сообщение: Re: join tables vs. denormalization by trigger