How to check if VACUUM operations are working?

From: Miguel Arroz <arroz(at)guiamac(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to check if VACUUM operations are working?
Date: 2006-09-05 23:07:51
Message-ID: F5084123-32F1-4E92-B6BE-112C5E52719A@guiamac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sriram Dandapani 2006-09-06 05:45:40 transactoin id wraparound problem
Previous Message Eamonn Kent 2006-09-05 22:38:21 Setting CLIENT_MIN_MESSAGES dynamically...