Re: tuning our database by increasing shared buffer

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: tuning our database by increasing shared buffer
Дата
Msg-id 4A41F0BD0200002500027EDA@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: tuning our database by increasing shared buffer  ("Allgood, John" <jallgood@ohl.com>)
Список pgsql-admin
"Allgood, John" <jallgood@ohl.com> wrote:

> What exactly am I looking for

> INFO:  free space map contains 2667 pages in 22 relations
> DETAIL:  A total of 3008 page slots are in use (including overhead).
> 3008 page slots are required to track all free space.
> Current limits are:  153600 page slots, 1000 relations, using 965
kB.

This is saying that limits of 3008 and 22 would have (barely) been
sufficient as of the vacuum run.  You want to leave a little room
above that, but if you're consistently getting numbers on this order
of magnitude, you could reduce the fsm settings from 153600 and 1000
and get back a little RAM for additional cache space.

-Kevin

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

Предыдущее
От: "Allgood, John"
Дата:
Сообщение: Re: tuning our database by increasing shared buffer
Следующее
От: Green Idol
Дата:
Сообщение: himanshu purohit wants you to be a Green Idol.