Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 941532E463D for ; Thu, 24 Jan 2008 14:41:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70889-06-3 for ; Thu, 24 Jan 2008 14:40:59 -0400 (AST) Received: from QMTA01.emeryville.ca.mail.comcast.net (qmta01.emeryville.ca.mail.comcast.net [76.96.30.16]) by postgresql.org (Postfix) with ESMTP id 534622E335B for ; Thu, 24 Jan 2008 14:00:15 -0400 (AST) Received: from OMTA10.emeryville.ca.mail.comcast.net ([76.96.30.28]) by QMTA01.emeryville.ca.mail.comcast.net with comcast id h0RZ1Y0020cQ2SL0A0fq00; Thu, 24 Jan 2008 18:00:13 +0000 Received: from [192.168.1.2] ([69.139.132.79]) by OMTA10.emeryville.ca.mail.comcast.net with comcast id h60C1Y00K1iwKaV8W00000; Thu, 24 Jan 2008 18:00:13 +0000 X-Authority-Analysis: v=1.0 c=1 a=ge7SWoZg_3MA:10 a=nDZEkuFarxrwO_Gm844A:9 a=1IiT-oQ8s2825yqhC6Xg-kavhmkA:4 a=LY0hPdMaydYA:10 Message-ID: <4798D238.7070002@ieee.org> Date: Thu, 24 Jan 2008 13:00:24 -0500 From: Rick Schumeyer User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Configuration settings (shared_buffers, etc) in Linux: puzzled Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/218 X-Sequence-Number: 28457 On a linux box (Linux db1 2.6.18.8-md #1 SMP Wed May 23 17:21:37 EDT 2007 i686 GNU/Linux) I edited postgresql.conf and changed: shared_buffers = 5000 work_mem = 16384 max_stack_depth = 4096 and then restarted postgres. The puzzling part is that postgres actually started. When I have done this on other boxes, I had to edit kernel settings to allow for more shared memory. The kernel settings are currently: shmmax: 33554432 shmall: 2097152 I would have expected to need to increase these before postgres would run. I have a nagging suspicion that something isn't right. Like it's not actually reading the conf file, or I might have a problem on reboot. I'm not sure if I'm worrying about nothing, or if something weird is going on.