Re: autovacuum not working?

> From: Bill Moran [mailto:wmoran@collaborativefusion.com]
> 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
>

Yup, that was it.

Thanks.

Medora