On 9/12/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > On 9/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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
