running only pg_autovacuum for one week

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: running only pg_autovacuum for one week
Date: 2004-08-02 13:08:26
Message-ID: 410E3CCA.9090805@bigfoot.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,
I did the experiment of running only the autovacuum for one week without
running my daily autovacuum full and reindex on heavy updated/inserted
tables.
Yesterday I reenabled the vacuum full and reindex and, as you can see
from the attachment, I recover 600MB of wasted space.

Regards
Gaetano Mendola

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBDjzJ7UpzwH2SGd4RAvq0AKDYWd1yfdZDcTSsnfr8lrkcWFIftwCfRMrZ
qEyKk6YppI6mM1scBRgdMHg=
=4M5I
-----END PGP SIGNATURE-----

Attachment Content-Type Size
image/png 4.3 KB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Anjan Dave 2004-08-02 15:27:45 perl(Pg) error on contrib package
Previous Message Mohammad Tanvir Huda 2004-08-01 03:54:48 Re: How can i start up POSTMASTER from unprivilege account