On 9/12/07, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
Aren't you mixing up REINDEX and CLUSTER?
Regards
MP
On 9/12/07, ruben@xxxxxxxxxxxx <ruben@xxxxxxxxxxxx> wrote:
> > Try a REINDEX. VACUUM FULL is especially hard on the indexes, and it's
> > easy for them to seriously bloat.
>
> Reindex is done everyday after VACUUM FULL VERBOSE ANALYZE. I save also
> the output averyday and save it into a log, and I can check that it is
> done properly.
Then you're vacuum full is wasted. A reindex accomplishes the same
thing, plus shrinks indexes (vacuum full can bloat indexes).
Aren't you mixing up REINDEX and CLUSTER?
Regards
MP
