When the last vacuum occured? It's necessary to run it now?

From: "Thiago Fernandes Moesch" <thiago(at)dinamize(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: When the last vacuum occured? It's necessary to run it now?
Date: 2003-10-27 17:52:16
Message-ID: BPEGLBDLDAGEAIKHCNJIOEPOCFAA.thiago@dinamize.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-10-27 18:10:45 Re: Timestamp docs weirdness
Previous Message strk 2003-10-27 17:23:12 DETOASTing in custom memory context