Re: VACUUM vs. REINDEX

Поиск
Список
Период
Сортировка
От Stefan Kaltenbrunner
Тема Re: VACUUM vs. REINDEX
Дата
Msg-id 44AF77FE.5040901@kaltenbrunner.cc
обсуждение исходный текст
Ответ на Re: VACUUM vs. REINDEX  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Список pgsql-performance
Steinar H. Gunderson wrote:
> On Fri, Jul 07, 2006 at 09:28:52PM -0400, Chris Hoover wrote:
>> 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.
>
> While we're at it, is there a good reason why we simply aren't upping the FSM
> defaults? It seems like a lot of people are being bitten by it, and adding
> more pages and relations is as you say cheap...

that is already done in -HEAD at the initdb stage:

...
selecting default shared_buffers/max_fsm_pages ... 4000/200000
...

Stefan

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

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: VACUUM vs. REINDEX
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Opteron/FreeBSD/PostgreSQL performance poor