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]
