On 9/12/07, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>
> On 9/12/07, ruben@rentalia.com <ruben@rentalia.com> 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