Re: When the last vacuum occured? It's necessary to run

From: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>
To: Thiago Fernandes Moesch <thiago(at)dinamize(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: When the last vacuum occured? It's necessary to run
Date: 2003-10-28 05:40:53
Message-ID: 3F9E0165.3070807@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2003-10-28 05:43:57 Re: Open items
Previous Message Shridhar Daithankar 2003-10-28 05:40:39 Re: Duplicating transaction information in indexes and