how often should I run Vacuum
how often should I run Vacuum
От:
"Leong, Fushan" <fushan.leong@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
Re: how often should I run Vacuum
От:
"MR" <none@none.com>
Дата:
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"" 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