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 EB08A5286E for ; Fri, 3 Jun 2005 06:11:48 -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 86915-10 for ; Fri, 3 Jun 2005 09:11:42 +0000 (GMT) Received: from linda-3.paradise.net.nz (bm-3a.paradise.net.nz [202.0.58.22]) by svr1.postgresql.org (Postfix) with ESMTP id 02D1E52851 for ; Fri, 3 Jun 2005 06:11:38 -0300 (ADT) Received: from smtp-2.paradise.net.nz (smtp-2b.paradise.net.nz [202.0.32.211]) by linda-3.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IHI00HAD47F24@linda-3.paradise.net.nz> for pgsql-performance@postgresql.org; Fri, 03 Jun 2005 21:11:39 +1200 (NZST) Received: from [192.168.1.11] (218-101-13-183.paradise.net.nz [218.101.13.183]) by smtp-2.paradise.net.nz (Postfix) with ESMTP id 004569F569; Fri, 03 Jun 2005 21:10:26 +1200 (NZST) Date: Fri, 03 Jun 2005 21:10:24 +1200 From: Mark Kirkwood Subject: Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance In-reply-to: <1117788544.4380.79.camel@fandelm.ecommit.de> To: Martin Fandel Cc: pgsql-performance@postgresql.org Message-id: <42A01E80.2030507@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 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> <1117788544.4380.79.camel@fandelm.ecommit.de> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.167 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/64 X-Sequence-Number: 12702 Martin Fandel wrote: > Aah ok :) > > I've set my values now as follow (2GB RAM): > > SHMMAX=`cat /proc/meminfo | grep MemTotal | cut -d: -f 2 | awk '{print > $1*1024/3}'` > echo kernel.shmmax=${SHMMAX} >> /etc/sysctl.conf > SHMALL=`expr ${SHMALL} / 4096 \* \( 4096 / 16 \)` > echo kernel.shmall=${SHMALL} >> /etc/sysctl.conf > > sysctl.conf: > kernel.shmmax=708329472 > kernel.shmall=44270592 > > postgresql.conf: > max_connections=500 > shared_buffers=40000 # ~312MB, min. 1000, max ~ 83000 > Hmmm - shmall set to 168G... err why? Apologies for nit picking a little - but shmall seems unreasonably high. I can't see much reason for setting it bigger than (physical RAM in bytes)/4096 myself. So in your case this is 2*(1024*1024*1024)/4096 = 524288 Cheers Mark