[Pkg-postgresql-public] 8.0.3 pg_autovacuum not working

[Stephen Frost]

--X4/Ax69dZtgs1rWz
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Thomas Mueller (tmm@tmueller.com) wrote:
> > 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.
>=20
> In the meantime I'm sure that the daemon doesn't work. I did: 'vacuumdb
> --all --verbose --analyze' and got such results:
>=20
> 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
>=20
> The table hasn't been vacuumed for a long time.

I've been wondering about this myself and see it happening on my systems
too..  I'll try and dig deeper into it tommorow.

> I've set avac_debug=3D999 (I found no documentation what's the maximum) in
> the config but nothing is logged.
>=20
> 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"

Does it actually do anything?

	Thanks,

		Stephen

--X4/Ax69dZtgs1rWz
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCpL1jrzgMPqB3kigRAsKuAJ96+sKK4TIr/rUjMSD+k0+4yCm4LACfWVKv
+Wd6GWDCmtPrC3cRfCcd23Q=
=R4Xl
-----END PGP SIGNATURE-----

--X4/Ax69dZtgs1rWz--