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"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
