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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pdxpug by date

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