Questions tagged [shmmax]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
3answers
4k views

What is the default maximum value for /proc/sys/kernel/shmmax

I am having an amiguity as to what the maximum value in shmmax should be set. After having a look at my system's statistics, it shows the following: #cat /proc/sys/kernel/shmmax ...
2
votes
1answer
285 views

High shmmax value in Redhat 6.3

We are using Redhat 6.3 with 30G RAM to host our Postgres server. The (default) shmmax value is 68,719,476,736 In some forums I have read that having an shmmax value larger than the RAM causes ...
2
votes
2answers
11k views

PostgreSQL server failed to start: request for a shared memory segment exceeded your kernel's SHMMAX parameter

I increased PostgreSQL's shared buffer (among other settings) to 4096M and now PostgreSQL fails to start, giving the error message below. Should I change the kernel's SHMMAX parameter to 4096M? The ...
12
votes
4answers
90k views

How to set shmall, shmmax, shmmin, etc … in general and for postgresql

I've used the documentation from PostgreSQL to set it for example this config: >>> cat /proc/meminfo MemTotal: 16345480 kB MemFree: 1770128 kB Buffers: 382184 kB ...
9
votes
2answers
16k views

Postgresql Performance - Adjusting SHMMAX and SHMALL

I've read just about everything there is online about improving postgres performance, but the "right" values for SHMMAX and SHMALL still elude me. The consensus seems to be SHMMAX = total_memory/4 ...
1
vote
3answers
11k views

shmmax setting in sysctl.conf not taking effect

We are running RHEL 4 Update 6 and I am going through an Oracle installation. As per the Oracle Installation Guide I am trying to update the shmmax value. As per the guide I have added the following ...
7
votes
3answers
5k views

how to set the shmmax parameter on mac os x

how should I set the shm* values in Mac Os X 10.5.6 Leopard in a persistent manner?