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 E19E45287E for ; Wed, 1 Jun 2005 03:45:46 -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 05147-03 for ; Wed, 1 Jun 2005 06:45:43 +0000 (GMT) Received: from ebrsrv01.ebravo.it (host53-205.pool8534.interbusiness.it [85.34.205.53]) by svr1.postgresql.org (Postfix) with ESMTP id 021FF5287A for ; Wed, 1 Jun 2005 03:45:37 -0300 (ADT) Received: from [192.168.11.103] ([192.168.11.103]) (authenticated) by ebrsrv01.ebravo.it (8.11.6/8.12.5) with ESMTP id j516iKY25988; Wed, 1 Jun 2005 08:44:20 +0200 Message-ID: <429D5942.6020502@streppone.it> Date: Wed, 01 Jun 2005 08:44:18 +0200 From: Cosimo Streppone User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: it, it-it, en-us, en MIME-Version: 1.0 To: Mark Kirkwood Cc: Postgresql Performance Subject: Re: postgresql-8.0.1 performance tuning References: <1117201312.7060.6.camel@fandelm.ecommit.de> <429D47FD.7090501@streppone.it> <429D56B2.9070302@paradise.net.nz> In-Reply-To: <429D56B2.9070302@paradise.net.nz> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/4 X-Sequence-Number: 12642 Mark Kirkwood ha scritto: > 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 Sorry, I thought "shmall" but written "shmmax". Thanks Mark! -- Cosimo