On Mon, 2004-08-02 at 07:08, Gaetano Mendola wrote: > -----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.
autovacuum is a daemon. You don't run it once a week, you set it loose and forget about it. Unless you're running it then shutting it down, running once a week is unnecessary. Also, what are you fsm settings in the postgresql.conf file? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
