Re: VACUUM FULL vs CLUSTER

On Tue, Sep 20, 2005 at 14:53:19 -0400,
  Markus Benne <markus@m-bass.com> 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).