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