Re: autovacuum not working?

In response to "Medora Schauer" <mschauer@fairfield.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.