running only pg_autovacuum for one week - Mailing list pgsql-admin

From Gaetano Mendola
Subject running only pg_autovacuum for one week
Date
Msg-id 410E3CCA.9090805@bigfoot.com
Whole thread Raw
Responses Re: running only pg_autovacuum for one week
List 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

pgsql-admin by date:

Previous
From: Steve
Date:
Subject: Re: please please please PLEASE help!
Next
From: "Anjan Dave"
Date:
Subject: perl(Pg) error on contrib package