Re: Recording vacuum/analyze/dump times - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: Recording vacuum/analyze/dump times
Date
Msg-id 422CA3C4.2050901@zeut.net
Whole thread Raw
In response to Recording vacuum/analyze/dump times  ("Jim Buttafuoco" <jim@contactbda.com>)
Responses Re: Recording vacuum/analyze/dump times  ("Jim Buttafuoco" <jim@contactbda.com>)
List pgsql-hackers
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
>  
>

For what it's worth, integrated pg_autovacuum will have something like 
this.  At least my initial design does, since the autovacuum daemon 
needs to know remember when the last time a table was vacuumed.



pgsql-hackers by date:

Previous
From: Ioannis Theoharis
Date:
Subject: Re: About b-tree usage
Next
From: "Jim Buttafuoco"
Date:
Subject: Re: Recording vacuum/analyze/dump times