shared_buffers revisited

Поиск
Список
Период
Сортировка
От Thalis A. Kalfigopoulos
Тема shared_buffers revisited
Дата
Msg-id Pine.LNX.4.21.0107201705270.12926-100000@aluminum.cs.pitt.edu
обсуждение исходный текст
Ответы Re: shared_buffers revisited  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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 it
requestsa shmsegment of 336404480 bytes. Where is the fallacy in my math? 

TIA,
thalis



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Delegating User creation
Следующее
От: "IRWIN,KEITH (Non-HP-Corvallis,ex1)"
Дата:
Сообщение: Does dropping a column from a table mess up foreign keys?