Postgres Pro
Downloads
Home   >   mailing lists

Re: [Again] Postgres performance problem - Mailing list pgsql-performance

From Mikko Partio
Subject Re: [Again] Postgres performance problem
Date
Msg-id 2ca799770709121156l7ddbb20agf8086e8bfcbc881a@mail.gmail.com
Whole thread Raw
In response to Re: [Again] Postgres performance problem  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: [Again] Postgres performance problem
List pgsql-performance
Tree view


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


pgsql-performance by date:

Previous
From: Brian Hurt
Date:
Subject: Re: [Again] Postgres performance problem
Next
From: "Scott Marlowe"
Date:
Subject: Re: [Again] Postgres performance problem