Questions tagged [shmmax]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

Is a value of 18446744073692774399 normal for kernel.shmmax? [duplicate]

Context: web server hosted on DigitalOcean with a PostgreSQL database. We were experiencing recurring database crashes for unknown reasons. Eventually I nailed down a faulty query that was overloading ...
user avatar
  • 101
4 votes
3 answers
5k 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 ...
user avatar
2 votes
1 answer
300 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 ...
user avatar
  • 151
3 votes
2 answers
13k 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 ...
user avatar
  • 1,429
12 votes
4 answers
92k 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 ...
user avatar
  • 232
9 votes
2 answers
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 ...
user avatar
  • 491
1 vote
3 answers
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 ...
user avatar
  • 192
7 votes
3 answers
6k 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?
user avatar
  • 885