On Wed, Dec 07, 2005 at 12:11:22PM +0200, Sim Zacks wrote: > select version() > "PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC > i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3, > pie-8.7.7.1)" > > I am using PG_Autovacuum with postgresql 8.01 and it doesn't seem to be > doing anything. I've seen it work on other machines where a log item is > entered each time a table is touched. > > I tried starting it with pg_autovacumm -d 1 -U postgres > (I purposely didn't daemonize it because I wanted to see what it was > doing) and it showed that it was adding all the tables, but then it just > sat there for 2 hours without doing anything else. > > The stats_collector and stats_row_level are both set to true. > > > Neither the postgresql.log file nor the pg_autovacuum.log file have > anything about it in them. Try -d 2; it should give enough info to tell if it's at least checking tables. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
