How to check if VACUUM operations are working? - Mailing list pgsql-admin

From Miguel Arroz
Subject How to check if VACUUM operations are working?
Date
Msg-id F5084123-32F1-4E92-B6BE-112C5E52719A@guiamac.com
Whole thread Raw
Responses Re: How to check if VACUUM operations are working?  (Niklas Johansson <spot@tele2.se>)
List pgsql-admin
Hi!

   I have PgSQL 8.0.* installed on a Mac OS X Server machine.

   I setup a LaunchDeamon to run a vacuum command every night. The
problem is that LaunchDeamon still lacks some features, one of them
is logging... so, I'm not entirely sure if the vacuum operations
actually runs.

   Is there any way to "ask" the database about it's status, related
to vacuum, like when was it vacuumed last time, or some other info
that may assure the script is running fine.

   Yours

Miguel Arroz

       "GUERRA E' PAZ
        LIBERDADE E' ESCRAVIDAO
        IGNORANCIA E' FORCA"       -- 1984

Miguel Arroz
http://www.ipragma.com




pgsql-admin by date:

Previous
From: "Eamonn Kent"
Date:
Subject: Setting CLIENT_MIN_MESSAGES dynamically...
Next
From: "Sriram Dandapani"
Date:
Subject: transactoin id wraparound problem