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.
