|
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. Am I missing something? Should there be something in the
log file to indicate that autovacuum has run? I’m attaching my conf file. Medora Schauer |
postgresql.conf
Description: postgresql.conf
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
