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