pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <markir@coretech.co.nz>
To: pgsql-docs@postgresql.org
Subject: Instructions for Linux ipc config
Date: Fri, 04 Feb 2005 12:06:08 +1300
Message-ID: <4202AE60.6000706@coretech.co.nz> (raw)

Glancing over these as I was doing the FreeBSD patch, I noticed some
scope for modernization there plus a possible error to correct:

i) we could standardize the change method to use sysctl instead of
echo'ing things into /proc/kernel/* structures (unless there is some
reason for this to be preferable?)

ii) we are recommending setting kernel.shmall equal to kernel.shmmax. I
think this is incorrect or strange anyway :

examining 2.6.10 src I see

./include/linux/shm.h:16: #define SHMALL (SHMMAX/PAGE_SIZE*(SHMMNI/16))
/* max shm system wide (pages) */

i.e. kernel.shmall really is in pages. So our suggested settings of:

kernel.shmall = 134217728
kernel.shmmax = 134217728


allow PAGE_SIZE  128M segments to be created... thats 4096 of 'em on
most common HW. This is probably more than most systems would need or
want (and does setting this value too high have a performance impact?).

One option is to follow what we have said for the BSD's i.e:

kernel.shmall = 32768

or leave shmall at its default (commonly 2097152).

What do people think?


regards

Mark




view thread (6+ messages)  latest in thread

Message-ID: <4202AE60.6000706@coretech.co.nz>
Permalink:  ../4202AE60.6000706@coretech.co.nz/
Also on:    postgresql.org/message-id/4202AE60.6000706@coretech.co.nz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: markir@coretech.co.nz
  Subject: Re: Instructions for Linux ipc config
  In-Reply-To: <4202AE60.6000706@coretech.co.nz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox