When vaccuum full should be performed with postgresql-8.1 and autovaccuum?

From: Arnau <arnaulist(at)andromeiberica(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: When vaccuum full should be performed with postgresql-8.1 and autovaccuum?
Date: 2006-09-18 10:18:18
Message-ID: 450E726A.6040508@andromeiberica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I'm migrating our DDBB from postgresql 7.4 to postgresql 8.1. In
postgreql 7.4 we don't have autovaccum running. So, every night before
doing the daily backup we do a "vaccuumdb -f -z" for each DB. My doubt
is, the autovaccuum with the version 8.1 is started by default and I
don't know how often I should perform the "vaccuumdb -f -z" or now it's
not necessary to do it at all.

Thank you very much
--
Arnau

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rafaqat Ali 2006-09-18 10:20:23 Re: test
Previous Message Rafaqat Ali 2006-09-18 08:18:43 test