Thread: how often should I run Vacuum

how often should I run Vacuum

From
"Leong, Fushan"
Date:
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

Re: how often should I run Vacuum

From
"MR"
Date:
Your data needs to be vacuumed whenever lots of updates and/or deletes occur
in your tables.

Which brings me to my question... why doesn't postgres have an auto-vacuum?

- MR

""Leong, Fushan"" <fushan.leong@SonoSite.com> wrote in message
news:2DFBC8374F5A0F4E954C07C158844F323886CE@milton.sonosite.com...
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster