Re: When the last vacuum occured? It's necessary to run - Mailing list pgsql-hackers

From Shridhar Daithankar
Subject Re: When the last vacuum occured? It's necessary to run
Date
Msg-id 3F9E0165.3070807@myrealbox.com
Whole thread Raw
In response to When the last vacuum occured? It's necessary to run it now?  ("Thiago Fernandes Moesch" <thiago@dinamize.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Duplicating transaction information in indexes and
Next
From: Larry Rosenman
Date:
Subject: Re: Open items