PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax

Поиск
Список
Период
Сортировка
От Mel Llaguno
Тема PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax
Дата
Msg-id E1FB7FBAE29E634FA58D6CC0D59F288B11EF7329@CH1PRD0511MB442.namprd05.prod.outlook.com
обсуждение исходный текст
Ответы Re: PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax
Re: PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax
Список pgsql-admin
Дерево обсуждения
All,

I'm wondering about how postgresql calculates the value for shared buffers as I see some discrepancies with what the following script provides versus what is recommended in the pgctl.log when the database fails to start.

#!/bin/bash
# simple shmsetup script
page_size=`getconf PAGE_SIZE`
phys_pages=`getconf _PHYS_PAGES`
shmall=`expr $phys_pages / 2`
shmmax=`expr $shmall \* $page_size` 
echo kernel.shmmax = $shmmax
echo kernel.shmall = $shmall

Any pointers which would explain these differences would be greatly appreciate. Ultimately, I'd like to calculate the expected kernel.shmmax which matches postgresql's shmget() call.

TIA,

Mel 

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

Предыдущее
От: Dev Kumkar
Дата:
Сообщение: Re: Facing authentication error on postgres 9.2 -> dblink functions
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax