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

PostgreSQL 8.4 tuning question

From: "Ewan, Michael" <michael(dot)ewan(at)intel(dot)com>
To: Portland PostgreSQL <pdxpug(at)postgresql(dot)org>
Subject: PostgreSQL 8.4 tuning question
Date: 2009-07-09 21:56:09
Message-ID: 66C9C47441840949A66773F8F0D9D6A76F84A0DF@rrsmsx503.amr.corp.intel.com (view raw or flat)
Thread:
Lists: pdxpug
I'm installing a new DB server on an Intel Xeon X5460 server (eight cores) with 32GB memory.  The kernel resources section (17.4) of the manual says to check kernel.shmmax and kernel.shmall, and set them to something like 128MB and 2M pages respectively.  However the defaults on SuSE SLES 10 are 

kernel.shmmax = 18446744073709551615
kernel.shmall = 1152921504606846720

I'm assuming I should just shake my head, walk away, and not try to figure out what Novell is doing here.  Anyone have any experience with PostgreSQL on SuSE SLES 10?  Any other tuning issues I should for?





In response to

  • Re: Hey hey at 2009-03-27 14:42:32 from Selena Deckelmann

Responses

pdxpug by date

Next:From: Mark WongDate: 2009-07-10 02:58:01
Subject: July Meeting 7/16/2009 - PostGIS and the Census Data
Previous:From: Webb SpragueDate: 2009-06-21 19:39:45
Subject: Re: June meeting recap!

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