#shmmax

Solution: how to set the shmmax parameter on mac os x #programming #dev #it

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?

Answer [by pjz]: how to set the shmmax parameter on mac os x

What do you get when you run ‘sysctl -p’ ? does it load your settings from /etc/sysctl.conf? What file is listed as default when you do ‘sysctl help’ ?

Answer [by Alex. S.]: how to set the shmmax parameter on…

Fix: Postgresql Performance – Adjusting SHMMAX and SHMALL #programming #development #answer

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 and SHMALL = total_memory/2 are safe starting values.

However, SHMALL can be measured in pages or bytes and I can’t find any info about which is…