Skip site navigation (1) Skip section navigation (2)

Re: Advice sought : new database server

From: Shaun Thomas <sthomas(at)peak6(dot)com>
To: Jochen Erwied <jochen(at)pgsql-performance(dot)erwied(dot)eu>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Advice sought : new database server
Date: 2012-03-08 16:18:30
Message-ID: 4F58DBD6.4080108@peak6.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)peak6(dot)com

______________________________________________

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

In response to

pgsql-performance by date

Next:From: Rory Campbell-LangeDate: 2012-03-09 11:15:58
Subject: Comments requested on IO performance : new db server
Previous:From: Jochen ErwiedDate: 2012-03-08 16:15:58
Subject: Re: Advice sought : new database server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group