Re: Subtly Bad Things Linux May Be Doing To PostgreSQL
by DrJokepu on Thursday April 03, 2014 @04:29AM
(#7521571)
Not relevant since PostgreSQL 9.3 as PostgreSQL now uses Posix shared memory / mmap rather that System V.
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL
by kev009 on Thursday April 03, 2014 @04:08AM
(#7521521)
I don't think this has any direct influence on performance.
It was necessary to increase the default limits for larger shared_buffers, etc on pgsql prior to 9.3 where SysV shared memory was used, but this was common to many *nix operating systems.
SHMMAXPGS, SHMMAX in postgresql.conf
in the
sysctl.conf kern.ipc.shmall kern.ipc.shmall