> From: Bill Moran [mailto:wmoran@xxxxxxxxxxxxxxxxxxxxxxx] > In response to "Medora Schauer" <mschauer@xxxxxxxxxxxxx>: > > > 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
