Re: Maxium Share Memory in Debian 64bit

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Maxium Share Memory in Debian 64bit
Дата
Msg-id 4F47E8F8.4090108@hogranch.com
обсуждение исходный текст
Ответ на Maxium Share Memory in Debian 64bit  (Prashant Bharucha <prashantbharucha@yahoo.ca>)
Список pgsql-general
On 02/24/12 11:41 AM, Prashant Bharucha wrote:
> Hello All
>
> Could you please help to figure out how much maxium memory can
> allocated in Shared Memory on Debian 64 bit OS ?
>

I rarely set shared_buffers over about 2GB even on machines with 48GB or
more ram.   its a case of diminishing returns, and leaving that extra
memory available for OS file system caching (as well as non-shared
things like work_mem, maintenance_work_mem) is usually the better choice.




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


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

Предыдущее
От: Willem Buitendyk
Дата:
Сообщение: Re: Upgrade to 9.1 causing function problem
Следующее
От: "Igor Neyman"
Дата:
Сообщение: Re: Stability in Windows?