Postgres Pro
Downloads
Home   >   mailing lists

SHMMAX and SHMALL question - Mailing list pgsql-general

From DM
Subject SHMMAX and SHMALL question
Date
Msg-id AANLkTimYwdqdvAPDSgMME4Vz=wRaLP9cP1NUZX3iTTF5@mail.gmail.com
Whole thread Raw
Responses Re: SHMMAX and SHMALL question
Re: SHMMAX and SHMALL question
List pgsql-general
Tree view
Firstof all sorry for posting linux kernel question in pgsql-general, but i am trying to figure out what value to set for postgresql db server.

RAM = 16GB, what value should i set for shmall?

 If i set shmall to 4294967296 (4GB), current PAGE_SIZE is 4096 should i need to set my shmmax = 4294967296*4096 = 17592186044416?


cat /proc/sys/kernel/shmall
4294967296

getconf PAGE_SIZE
4096

Current Shmmax -
==> cat /proc/sys/kernel/shmmax
68719476736

should i need to increase my shmmax to 17592186044416?

also what value should i need to set shmall?

what happens if i set shmmax to lower  than the expected size?


Thanks
Deepak

pgsql-general by date:

Previous
From: "Karsten Hilbert"
Date:
Subject: Re: Are there any projects interested in object functionality? (+ rule bases)
Next
From: Andy Colson
Date:
Subject: Re: Are there any projects interested in object functionality? (+ rule bases)