Managing Kernal resource
От | Ashish Karalkar |
---|---|
Тема | Managing Kernal resource |
Дата | |
Msg-id | 004201c7a9b1$147efa80$170211ac@LIONKING.COM обсуждение исходный текст |
Ответы |
Re: Managing Kernal resource
|
Список | pgsql-general |
Name | Description | Reasonable Values |
---|---|---|
SHMMAX | Maximum size of shared memory segment (bytes) | 512 KB + 8192 * buffers + extra ... infinity |
"The most important shared memory parameter is SHMMAX, the maximum size, in bytes, that a shared memory segment can have. If you get an error message from shmget along the lines of Invalid argument, it is possible that this limit has been exceeded. The size of the required shared memory segments varies both with the number of requested buffers (-B option) and the number of allowed connections (-N option), although the former is the dominant item. (You can therefore, as a temporary solution, lower these settings to get rid of the failures.) As a rough approximation you can estimate the required segment size as the number of buffers times the block size (8192 KB by default) plus ample overhead (at least half a megabyte). All error messages will contain the size of the failed allocation request. "
В списке pgsql-general по дате отправления: