Re: Advice sought : new database server - Mailing list pgsql-performance

From Shaun Thomas
Subject Re: Advice sought : new database server
Date
Msg-id 4F58DBD6.4080108@peak6.com
Whole thread Raw
In response to Re: Advice sought : new database server  (Jochen Erwied <jochen@pgsql-performance.erwied.eu>)
List 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@peak6.com

______________________________________________

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

pgsql-performance by date:

Previous
From: Jochen Erwied
Date:
Subject: Re: Advice sought : new database server
Next
From: Rory Campbell-Lange
Date:
Subject: Comments requested on IO performance : new db server