On Tue, Sep 20, 2005 at 14:53:19 -0400, Markus Benne <[EMAIL PROTECTED]> wrote: > I have a table that is purged by 25% each night. I'd like to do a > vacuum nightly after the purge to reclaim the space, but I think I'll > still need to do a vacuum full weekly. > > Would there be any benefit to doing a cluster instead of the vacuum?
If you have a proper FSM setting you shouldn't need to do vacuum fulls (unless you have an older version of postgres where index bloat might be an issue). ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings