--d6Gm4EdcadzBjdND
Content-Type: text/plain; charset=iso-8859-15
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Also sprach Adam (adam@albedo.art.pl)
> >   I want to be able to check if autovacuuming is working in my
> >postgresql setup. I have no idea how to find that out, so I asked =20
> >in the
> >postgresql lists. Someone suggested that I try to use pgadmin3 to =20
> >try to
> >monitor how many rows a table has in the data files.

Autovacuum logs to the logfile. You'll get an Error if it does not
start and a:

LOG:  autovacuum: processing database "w=F6rterbuch"
LOG:  autovacuum: processing database "mitarbeiter"
LOG:  autovacuum: processing database "inventar"

if it runs.

To get the number of rows use SELECT COUNT, eg in a shellskript like that:
$ echo "select count(*) from myTab" | psql myDB

This won't require you to install PGadmin.
--=20
Pedites pugnas decernent    http://www.jaegerseiten.de    Horrido!


http://www.net-tex.de                                 http://www.cryptomanc=
er.de

--d6Gm4EdcadzBjdND
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (NetBSD)

iD4DBQFFOnePEfTEHrP7rjMRAvJwAKCYRVXkxLu9q2nmWrhQ311KBTLcngCVHskp
wm3VO15P8cREz+UIIu9qvA==
=sKgz
-----END PGP SIGNATURE-----

--d6Gm4EdcadzBjdND--