how often should I run Vacuum

From: "Leong, Fushan" <fushan(dot)leong(at)SonoSite(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: how often should I run Vacuum
Date: 2001-11-28 22:56:45
Message-ID: 2DFBC8374F5A0F4E954C07C158844F323886CE@milton.sonosite.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi :

Want to get some idea about Vaccum function...

How often would you suggest to run Vaccum command?
Should I schedule to run in non-busy time like midnight?
Vaccum all or Vacuum for each individual table
Any tips for Vaccum?

thanks
Fushan

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vincent.Gaboriau 2001-11-29 09:01:45 Re: [HACKERS] upper and lower doesn't work with german
Previous Message Jeff Young 2001-11-28 20:20:41 Controlling Table/Index Location