This is what I was thinking about doing. It would be nicer if the system "just did it" for me. I have 100+'s of databases with 100+'s of tables in each and run pg_autovacuum on them all. I also do nightly dumps and any database that has been modified (my application keeps track). I was just thinking of using these dates as a check that the automated processes are working.
Jim ---------- Original Message ----------- From: Heikki Linnakangas <[EMAIL PROTECTED]> To: Jim Buttafuoco <[EMAIL PROTECTED]> Cc: pgsql-hackers@postgresql.org Sent: Mon, 7 Mar 2005 20:35:21 +0200 (EET) Subject: Re: [HACKERS] Recording vacuum/analyze/dump times > On Mon, 7 Mar 2005, Jim Buttafuoco wrote: > > > Its there a reason postgresql doesn't record vacuum/analyze and dump times > > in pg_class (or another table). This seems > > like it would be a very helpful feature. > > > > for pg_dump I would add an option --record=YES|NO > > for vacuum and analyze I would add a NORECORD|RECORD option > > You could easily do this in application level: > > CREATE TABLE vacuums (relname name, last_vacuum timestamp); > > Every time you vacuum, do: > > VACUUM foobar; UPDATE dumps set last_dump = now() WHERE relname = 'foobar'; > > Same for pg_dump. > > - Heikki > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ------- End of Original Message ------- ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings