[Pkg-postgresql-public] 8.0.3 pg_autovacuum not working

Thomas Mueller tmm@tmueller.com
Sat, 04 Jun 2005 18:55:11 +0200

Hi again,

> I've installed Postgresql 8.0.3 on Sarge. The pg server works fine but I
> think the autovacuum daemon doesn't, at least it doesn't log anything.

In the meantime I'm sure that the daemon doesn't work. I did: 'vacuumdb
--all --verbose --analyze' and got such results:

INFO:  "dbmail_messages": removed 36465 row versions in 685 pages
DETAIL:  CPU 0.11s/0.12u sec elapsed 2.09 sec.
INFO:  "dbmail_messages": found 36465 removable, 94241 nonremovable row
versions in 1834 pages

The table hasn't been vacuumed for a long time.

I've set avac_debug=999 (I found no documentation what's the maximum) in
the config but nothing is logged.

If I start the daemon manually logging works:
su postgres -c "/usr/lib/postgresql/8.0/bin/pg_autovacuum -p 5432 -L
/tmp/avc.log -d 999"

Now I'm lost - anyone any idea? Thanks!

http://www.tmueller.com for pgp key (95702B3B)