Re: [Again] Postgres performance problem

Поиск
Список
Период
Сортировка
От Mikko Partio
Тема Re: [Again] Postgres performance problem
Дата
Msg-id 2ca799770709121156l7ddbb20agf8086e8bfcbc881a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [Again] Postgres performance problem  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: [Again] Postgres performance problem  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance


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 по дате отправления:

Предыдущее
От: Brian Hurt
Дата:
Сообщение: Re: [Again] Postgres performance problem
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: [Again] Postgres performance problem