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

help / color / mirror / Atom feed
From: Shaun Thomas <sthomas@peak6.com>
To: Jochen Erwied <jochen@pgsql-performance.erwied.eu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Advice sought : new database server
Date: Thu, 8 Mar 2012 10:18:30 -0600
Message-ID: <4F58DBD6.4080108@peak6.com> (raw)
In-Reply-To: <417510800.20120308171558@erwied.eu>
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>
	<417510800.20120308171558@erwied.eu>

On 03/08/2012 10:15 AM, Jochen Erwied wrote:

> Shouldn't that be:
>
> kernel.shmmax = 4294967296
> kernel.shmmni = 4096
> kernel.shmall = 1572864

Oops! Yes. That's definitely it. I'm too accustomed to having those set 
automatically, and then setting these:

vm.swappiness = 0
vm.dirty_background_ratio = 1
vm.dirty_ratio = 10

Sorry about that!

-- 
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)

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

 · 

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, jochen@pgsql-performance.erwied.eu
  Subject: Re: Advice sought : new database server
  In-Reply-To: <4F58DBD6.4080108@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