Re: shared_buffers revisited

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: shared_buffers revisited
Дата
Msg-id 5453.995667806@sss.pgh.pa.us
обсуждение исходный текст
Ответ на shared_buffers revisited  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
Список pgsql-general
"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:
> Another minor issue that has come to my attention is that when I define
> shared_buffers=40000
> I assume that it'll need a shm segment of 40000*8192=327680000 bytes
> And so I set /proc/sys/kernel/shmall and shmmax accordingly only to find out that postmaster failes to start because
itrequests a shmsegment of 336404480 bytes. Where is the fallacy in my math? 

Shared buffers are not the only things we keep in shared memory ...

            regards, tom lane

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

Предыдущее
От: Nate Carlson
Дата:
Сообщение: Microsoft SQL Server Replication
Следующее
От: "Tim Barnard"
Дата:
Сообщение: Re: Language C - Console-based FrontEnd