Re: About autovacuum - Mailing list pgsql-performance

From Bill Moran
Subject Re: About autovacuum
Date
Msg-id 20070904150102.6441483b.wmoran@collaborativefusion.com
Whole thread Raw
In response to About autovacuum  (Jean-David Beyer <jeandavid8@verizon.net>)
List 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 by date:

Previous
From: "Walter Mauritz"
Date:
Subject: join tables vs. denormalization by trigger
Next
From: Mark Lewis
Date:
Subject: Re: join tables vs. denormalization by trigger