Re: Disadvantages on having too many page slots?

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: Disadvantages on having too many page slots?
Дата
Msg-id 1176910767.16187.79.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Disadvantages on having too many page slots?  (Francisco Reyes <lists@stringsutils.com>)
Ответы Re: Disadvantages on having too many page slots?
Список pgsql-general
> Other than hard disk space, are there any disadvantages on
> having a large number of page slots?

It's not using hard disk space, it's using shared memory, so you might
want to adjust it to make that memory available for other purposes...

> DETAIL:  A total of 2233472 page slots are in use (including overhead).
> 2233472 page slots are required to track all free space.
> Current limits are:  14000000 page slots, 1000 relations, using 82096 KB.

I'm not sure how much a difference would make to have ~60M of memory
more, but it could mean one more index in memory ;-)

Cheers,
Csaba.



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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Disadvantages on having too many page slots?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Disadvantages on having too many page slots?