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: | Raw Message | Whole Thread | 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 |
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 |