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


Mon, 27 Oct 2003 15:52:16 -0200
"Thiago Fernandes Moesch" <thiago@dinamize.com>
When the last vacuum occured? It's necessary to run it now?
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


Tue, 28 Oct 2003 11:10:53 +0530
Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
Re: When the last vacuum occured? It's necessary to run