Обсуждение: Re: [GENERAL] index bloat problem

Поиск
Список
Период
Сортировка

Re: [GENERAL] index bloat problem

От
Tom Lane
Дата:
Monika Cernikova <monika@microstep-mis.com> writes:
> Can you help me how to stop index growing or reindex database if I CAN'T
> STOP writing records?

I think you have max_fsm_pages set too small.

> max_fsm_pages = 400000

That corresponds to about 3Gb, or a tenth the size of your DB.  Not enough.

            regards, tom lane