Also sprach Adam (adam%albedo.art.pl@localhost) > > 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 > >in the > >postgresql lists. Someone suggested that I try to use pgadmin3 to > >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örterbuch" 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. -- Pedites pugnas decernent http://www.jaegerseiten.de Horrido! http://www.net-tex.de http://www.cryptomancer.de
Attachment:
pgpuWr7PrCuYs.pgp
Description: PGP signature