This is a known bug, and if fixed in CVS. It will be released as part
of 7.4.3, or just download pg_autovacuum.c and pg_autovacuum.h from cvs
and compile a new executable.
Matthew O'Connor
Jim C. Nasby wrote:
There's a bug in pg_autovacuum that makes it vacuum large tables way to
frequently.
og
There's a bug in pg_autovacuum that makes it vacuum large tables way to
frequently.
ogr=# select reltuples from pg_class where relname='ogr_summary';
reltuples
-
2.64411e+07
(1 row)
[2004-04-27 02:03:08 PM] table name: ogr."public"."ogr_results"
[2004-04-27 02:03:08 PM]