about shared_buffer and kernel.shmmax

Поиск
Список
Период
Сортировка
От wangqi
Тема about shared_buffer and kernel.shmmax
Дата
Msg-id 4FE29737.2040405@edgesoft.cn
обсуждение исходный текст
Ответы Re: about shared_buffer and kernel.shmmax  (Craig Ringer <ringerc@ringerc.id.au>)
Re: about shared_buffer and kernel.shmmax  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-admin
Hi everybody,
shared_buffer maximum limit is ?
I set shared_buffer more than 250G, I got error at startup pg.

------------------------------------------------------------------------
This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter. You can either reduce
the request size or reconfigure the kernel with larger SHMMAX. To reduce
the request size (currently 439371702272 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 52428800) and/or its max_connections
parameter (currently 104).
-------------------------------------------------------------------------

but now
kernel.shmmax = 966367641600
kernel.shmall = 235929600

 --
----------------------------------------------------
Yours sincerely,
Qi Wang
                         Edgesoft (China) Co.,Ltd
                         F26th Block B,Zhongli Building,
                         No.32 Huoju Road,
                         Hi-Tech Zone,Dalian,China
                         Zip:116023
                         Tel:+86-411-84753511
                         Fax:+86-411-84753577
                         http://www.edgesoft.cn
                         mailto:wangqi@edgesoft.cn
----------------------------------------------------


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

Предыдущее
От: Lonni J Friedman
Дата:
Сообщение: Re: pg_basebackup blocking all queries with horrible performance
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: about shared_buffer and kernel.shmmax