Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
89 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 ...
-1
votes
2answers
2k 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 ...
5
votes
3answers
22k views

How to set shmall, shmmax, shmni, 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 ...
7
votes
2answers
7k 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
6k 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 ...
6
votes
3answers
3k 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?