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 -- Bill Moran Collaborative Fusion Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend