Re: How should the correct value of shmmax be calculated for DWH(OLAP) server

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: How should the correct value of shmmax be calculated for DWH(OLAP) server
Дата
Msg-id 4647b0c67c2c5d4dc08032f1b11240665711af95.camel@cybertec.at
обсуждение исходный текст
Ответ на How should the correct value of shmmax be calculated for DWH (OLAP)server  ("Shukla, Sumeet" <ShuklaSu@advisory.com>)
Ответы Re: How should the correct value of shmmax be calculated for DWH(OLAP) server  ("Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>)
Список pgsql-admin
Дерево обсуждения 
Shukla, Sumeet wrote:
> Can someone please help me determine the appropriate value of kernel shmmax
> parameter for PostgreSQL configured for Data Warehouse use?

Simple. Set it to anything bigger than your "shared_buffers" setting.
If PostgreSQL manages to start, your setting is big enough.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: Pierre Ochsenbein
Дата:
Сообщение: pgpool versus which tool?
Следующее
От: "Gunnar \"Nick\" Bluth"
Дата:
Сообщение: Re: How should the correct value of shmmax be calculated for DWH(OLAP) server