> From: Bill Moran [mailto:[EMAIL PROTECTED]
> In response to "Medora Schauer" <[EMAIL PROTECTED]>:
>
> > 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
