X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4DBB4528C1 for ; Wed, 1 Jun 2005 03:33:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48147-02 for ; Wed, 1 Jun 2005 06:33:27 +0000 (GMT) Received: from linda-2.paradise.net.nz (bm-2a.paradise.net.nz [202.0.58.21]) by svr1.postgresql.org (Postfix) with ESMTP id 584A952887 for ; Wed, 1 Jun 2005 03:33:26 -0300 (ADT) Received: from smtp-2.paradise.net.nz (smtp-2b.paradise.net.nz [202.0.32.211]) by linda-2.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IHE00K467JPAL@linda-2.paradise.net.nz> for pgsql-performance@postgresql.org; Wed, 01 Jun 2005 18:33:26 +1200 (NZST) Received: from [192.168.1.11] (218-101-13-29.paradise.net.nz [218.101.13.29]) by smtp-2.paradise.net.nz (Postfix) with ESMTP id 29B7F9E91F; Wed, 01 Jun 2005 18:33:25 +1200 (NZST) Date: Wed, 01 Jun 2005 18:33:22 +1200 From: Mark Kirkwood Subject: Re: postgresql-8.0.1 performance tuning In-reply-to: <429D47FD.7090501@streppone.it> To: Cosimo Streppone Cc: Martin Fandel , Postgresql Performance list Message-id: <429D56B2.9070302@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=UTF-8 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050511) References: <1117201312.7060.6.camel@fandelm.ecommit.de> <429D47FD.7090501@streppone.it> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.069 tagged_above=0 required=5 tests=AWL, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: * X-Archive-Number: 200506/3 X-Sequence-Number: 12641 Cosimo Streppone wrote: > ######### Config ############ >> /etc/sysctl.conf: >> kernel.shmall = 786432000 >> kernel.shmmax = 786432000 > > > I think you have a problem here. > kernel.shmmax should *not* be set to an amount of RAM, but > to maximum number of shared memory pages, which on a typical linux system > is 4kb. Google around: > > > This is somewhat confusing : kernel.shmmax is in bytes (max single segment size) kernel.shmall is in (4k) pages (max system wide allocated segment pages) cheers Mark