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

help / color / mirror / Atom feed

From: Shaun Thomas <sthomas@peak6.com>
To: Craig James <cjames@emolecules.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: Rory Campbell-Lange <rory@campbell-lange.net>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Advice sought : new database server
Date: Wed, 7 Mar 2012 16:24:25 -0600
Message-ID: <4F57E019.8050002@peak6.com> (raw)
In-Reply-To: <CAFwQ8rf9pfAQgDwfxgrB3dt=9c2Hbu51DYU8jVeQC=mAWLQhjQ@mail.gmail.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>

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

To commit changes made this way:

sysctl -p

-- 
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@peak6.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email

view thread (21+ messages)  latest in thread

Message-ID: <4F57E019.8050002@peak6.com>
Permalink:  ../4F57E019.8050002@peak6.com/
Also on:    postgresql.org/message-id/4F57E019.8050002@peak6.com

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: sthomas@peak6.com, cjames@emolecules.com, mmoncure@gmail.com, rory@campbell-lange.net, scott.marlowe@gmail.com
  Subject: Re: Advice sought : new database server
  In-Reply-To: <4F57E019.8050002@peak6.com>

* 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