Welcome, Guest
Please Login or Register.    Lost Password?

DB: What are the IPC requirements for the database?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: DB: What are the IPC requirements for the database?
#12
DB: What are the IPC requirements for the database? 14 Years, 1 Month ago Karma: 2
The only system that we have seen problems with related to PostgreSQL's IPC are Solaris systems. On Solaris systems, we have tuned the PostgreSQL requirements down to run on a default installation, but if other software is using any of the shared memory, there may not be enough shared memory available to run our product.
You can change the amount of allowed shared memory by editing the /etc/system file, and adding or changing the following settings:

Code:

    set shmsys:shminfo_shmmax=0x2000000
    set shmsys:shminfo_shmmin=1
    set shmsys:shminfo_shmmni=256
    set shmsys:shminfo_shmseg=256
    set semsys:seminfo_semmap=256
    set semsys:seminfo_semmni=512
    set semsys:seminfo_semmns=512
    set semsys:seminfo_semmsl=32



One customer has also reported having to change "shmsys:shminfo_shmmin" to 100.

Default settings for Solaris 2.x:

shmmax: 1048576 (largest size of a shared memory segment)
shmmin: 1
shmseg: 6 (# of segments per process)
shmmni: 100 (# of segments systemwide)

The actual recommended value for SEMMAX is:

250kB + 8.2kB * #buffers + 14.2kB * #connections

The number of buffers is 2 * #connections, generally. The defaults for Postgres are 64 buffers, which means 32 connections. Our startup specifies 32 buffers and 16 connections instead. These settings will run on a default Solaris installation with no additional IPC use.
troy
Administrator
Posts: 231
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Birthday: 01/14
The administrator has disabled public write access.
 
Go to topPage: 1
Moderators: troy, Andyl