Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id AE2062E2368 for ; Sat, 17 Nov 2007 22:46:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 41771-06 for ; Sat, 17 Nov 2007 22:45:53 -0400 (AST) Received: from oxford.xeocode.com (bdv75-7-82-242-74-106.fbx.proxad.net [82.242.74.106]) by postgresql.org (Postfix) with ESMTP id CFAEB2E2D7A for ; Sat, 17 Nov 2007 22:45:58 -0400 (AST) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1Isb6F-0001dy-Nu; Thu, 15 Nov 2007 09:33:30 +0000 To: "Tena Sakai" Cc: Subject: Re: postgres bogged down beyond tolerance In-Reply-To: (Tena Sakai's message of "Wed\, 14 Nov 2007 09\:52\:29 -0800") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.sql" 1342) References: From: Gregory Stark Organization: EnterpriseDB Date: Thu, 15 Nov 2007 09:33:27 +0000 Message-ID: <87wssjx388.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.006 tagged_above=0 required=5 tests=BAYES_50=0.001, RCVD_IN_PBL=0.905, RDNS_DYNAMIC=0.1 X-Spam-Level: * X-Archive-Number: 200711/89 X-Sequence-Number: 29617 "Tena Sakai" writes: > Namely, I shutdown the database, issued two commands: > /sbin/sysctl -w kernel.shmmax=134217728 > /sbin/sysctl -w kernel.shmall=2097152 > and rebooted the computer. > > After it came up, I checked the shmmax and it is set > as 33554432. Which surprised me. Since I used -w > flag, I thought it should've written to /etc/sysctl.conf, > but there is no such entry at all and the data of this > file is from 2006. sysctl changes the values for the running kernel. /etc/sysctl is a file you edit manually to tell the boot scripts what values to store (using sysctl) so you don't have to run sysctl every time you reboot. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!