pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Jochen Erwied <jochen@pgsql-performance.erwied.eu>
To: Shaun Thomas <sthomas@peak6.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Advice sought : new database server
Date: Thu, 8 Mar 2012 17:15:58 +0100
Message-ID: <417510800.20120308171558@erwied.eu> (raw)
In-Reply-To: <4F57E019.8050002@peak6.com>
References: <20120304095838.GA3064@campbell-lange.net>
	<CAOR=d=1L=aunEtULW2sq9c-tAdZzSM6exi6wUw0w_zzjGLBRHQ@mail.gmail.com>
	<20120304183630.GA8902@campbell-lange.net>
	<CAFwQ8rc01cv61tvcUiyo=Xo_2g+kCges4PDosnPnpLP4x49SxQ@mail.gmail.com>
	<CAHyXU0yKEcG_BPMevJXVsLoZ=w7-VU29Ngrwp1eOOkPvvMYQ+A@mail.gmail.com>
	<CAFwQ8rf9pfAQgDwfxgrB3dt=9c2Hbu51DYU8jVeQC=mAWLQhjQ@mail.gmail.com>
	<4F57E019.8050002@peak6.com>

Wednesday, March 7, 2012, 11:24:25 PM you wrote:

> On 03/07/2012 03:07 PM, Craig James wrote:

>> echo 4294967296 >/proc/sys/kernel/shmmax # 4 GB shared memory
>> echo 4096 >/proc/sys/kernel/shmmni
>> echo 1572864 >/proc/sys/kernel/shmall # 6 GB max shared mem (block size
>> is 4096 bytes)

> For what it's worth, you can just make these entries in your 
> /etc/sysctl.conf file and it'll do the same thing a little more cleanly:

> vm.shmmax = 4294967296
> vm.shmmni = 4096
> vm.shmall = 1572864

Shouldn't that be:

kernel.shmmax = 4294967296
kernel.shmmni = 4096
kernel.shmall = 1572864

-- 
Jochen Erwied     |   home: jochen@erwied.eu     +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work: joe@mbs-software.de  +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile: jochen.erwied@vodafone.de       +49-173-5404164

view thread (21+ messages)  latest in thread

Message-ID: <417510800.20120308171558@erwied.eu>
Permalink:  ../417510800.20120308171558@erwied.eu/
Also on:    postgresql.org/message-id/417510800.20120308171558@erwied.eu

copy link · copy postgr.es

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-performance@postgresql.org
  Cc: jochen@pgsql-performance.erwied.eu, sthomas@peak6.com
  Subject: Re: Advice sought : new database server
  In-Reply-To: <417510800.20120308171558@erwied.eu>

* 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