| From: | DM <dm(dot)aeqa(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | SHMMAX and SHMALL question |
| Date: | 2011-01-22 01:34:57 |
| Message-ID: | AANLkTimYwdqdvAPDSgMME4Vz=wRaLP9cP1NUZX3iTTF5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Colson | 2011-01-22 02:07:36 | Re: Are there any projects interested in object functionality? (+ rule bases) |
| Previous Message | Karsten Hilbert | 2011-01-22 00:44:19 | Re: Are there any projects interested in object functionality? (+ rule bases) |