Re: autovacuum not working?

In response to "Medora Schauer" <mschauer(at)fairfield(dot)com>:

> I've recently moved to 8.1 and find that autovacuum doesn't seem to be
> working, at least not the way I expected it to. I need the tuple count
> for a table to be updated so indexes will be used when appropriate. I
> was expecting the tuples count for a table to be updated after
> autovacuum ran. This doesn't seem to be the case. I added 511 records
> to a previously empty table and waited over an hour. Tuples for the
> table (as per pgaccess) was 0. After I did a manual vacuum analyze it
> went to 511.

From your attached config file:

#autovacuum_vacuum_threshold = 1000 # min # of tuple updates before
# vacuum

--
Bill Moran
Collaborative Fusion Inc.