running only pg_autovacuum for one week

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема running only pg_autovacuum for one week
Дата
Msg-id 410E3CCA.9090805@bigfoot.com
обсуждение исходный текст
Ответы Re: running only pg_autovacuum for one week  ("Scott Marlowe" <smarlowe@qwest.net>)
Список 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-----

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Steve
Дата:
Сообщение: Re: please please please PLEASE help!
Следующее
От: "Anjan Dave"
Дата:
Сообщение: perl(Pg) error on contrib package