X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D36219FB2C2 for ; Wed, 16 Aug 2006 14:14:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 54388-06 for ; Wed, 16 Aug 2006 17:14:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id 66EDD9FB2A1 for ; Wed, 16 Aug 2006 14:14:43 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so828439nfc for ; Wed, 16 Aug 2006 10:14:41 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=NWOK20wmauts2PmK6D7HWunUEjTbTlV7n5SSaWC2PXmYEJEWk7Cc8oBcansSkpvLwkKR5cw3p7nu+WFrvOfvGB1+17tm5NXWBP7k/z3HBcFGKijAS1dWBFJn9gqexCb3PX8KxqNMtKJyKipsj3JBhviocTUdcxKH2XIHwli9an0= Received: by 10.49.29.3 with SMTP id g3mr864519nfj; Wed, 16 Aug 2006 08:34:24 -0700 (PDT) Received: by 10.78.158.10 with HTTP; Wed, 16 Aug 2006 08:34:24 -0700 (PDT) Message-ID: Date: Wed, 16 Aug 2006 09:34:24 -0600 From: "Carl Youngblood" To: pgsql-performance@postgresql.org Subject: Re: Beginner optimization questions, esp. regarding Tsearch2 In-Reply-To: <20060815192145.GI21363@pervasive.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <44DAFB2B.4070307@archonet.com> <20060815150529.GO27928@pervasive.com> <20060815192145.GI21363@pervasive.com> X-Google-Sender-Auth: 20e444ec5012ccc0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/267 X-Sequence-Number: 20452 The relevant portion of my sysctl.conf file looks like this: kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 65536 I understood it was a good idea to set shmmax to half of available memory (2GB in this case). I assume that I need to set shared_buffers slightly lower than 2GB for postgresql to start successfully. Carl On 8/15/06, Jim C. Nasby wrote: > On Tue, Aug 15, 2006 at 12:47:54PM -0600, Carl Youngblood wrote: > > I tried setting it to 2GB and postgres wouldn't start. Didn't > > investigate in much greater detail as to why it wouldn't start, but > > after switching it back to 1GB it started fine. > > Most likely because you didn't set the kernel's shared memory settings > high enough.