Re: VACUUM vs. REINDEX

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: VACUUM vs. REINDEX
Дата
Msg-id 200607072024.25142.jd@commandprompt.com
обсуждение исходный текст
Ответ на Re: VACUUM vs. REINDEX  ("Chris Hoover" <revoohc@gmail.com>)
Список pgsql-performance
> William,
>
> You need to increase your fsm settings.  The database is telling you it is
> trying to store 177K+ pages, but you have only provided it with 20K.  Since
> these pages are cheap, I would set your fsm up with at least the following.
>
> max_fsm_pages 500000
> max_fsm_relations 5000
>
> This should provide PostgreSQL with enough space to work.  You still might
> need to run one more vacuum full once you change the setting so that you
> can recover the space that was lost due to your fsm begin to small.
Yes he will need to run a vacuum full but I actually doubt he needs to
increase his max_fsm_pages that much, he just needs to vacuum more.

Joshua D. Drake

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Chris Hoover"
Дата:
Сообщение: Re: VACUUM vs. REINDEX
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: VACUUM vs. REINDEX