When the last vacuum occured? It's necessary to run it now?
Hi,
It would be great for maintainance if every object had a timestamp of
the last vaccum run on it. From time to time we're working with several
databases and I can't tell wich one needs a new vacuum.
Another important information would be the rate of disposable data in
every table (like old and delete records) it would help was to
determine if a vacuum is required.
Best regards,
Thiago Fernandes Moesch
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003
Thiago Fernandes Moesch wrote:
It would be great for maintainance if every object had a timestamp of
the last vaccum run on it. From time to time we're working with several
databases and I can't tell wich one needs a new vacuum.Another important information would be the rate of disposable data in
every table (like old and delete records) it would help was to
determine if a vacuum is required.
You could rather use autovacuum than adding timestamps to fields.
HTH
Shridhar