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

Reply via email to