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 8C5A8528CE
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri,  3 Jun 2005 06:19:57 -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 93536-08
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri,  3 Jun 2005 09:19:52 +0000 (GMT)
Received: from titan.ecommit.de (titan.ecommit.de [195.145.58.245])
	by svr1.postgresql.org (Postfix) with ESMTP id 270825286A
	for <pgsql-performance@postgresql.org>;
	Fri,  3 Jun 2005 06:19:51 -0300 (ADT)
Received: from titan.ecommit.de (localhost [127.0.0.1])
	by titan.ecommit.de (8.12.6/8.12.6/SuSE Linux 0.6) with ESMTP id
	j539Jn0A002424; Fri, 3 Jun 2005 11:19:49 +0200
Received: from titan.ecommit.de (root@localhost)
	by titan.ecommit.de (8.12.6/8.12.6/Submit) with ESMTP id j539JntS002385;
	Fri, 3 Jun 2005 11:19:49 +0200
Received: from fandelm.ecommit.de (fandelm.tc.de 192.168.252.51)
	by titan.ecommit.de (Scalix SMTP Relay 9.0.0.26)
	via ESMTP; Fri, 03 Jun 2005 11:19:48 +0200 (CEST)
Date: Fri, 3 Jun 2005 11:19:03 +0200
From: "Martin Fandel" <martin.fandel@alphyra-evs.de>
To: Mark Kirkwood <markir@paradise.net.nz>
Cc: pgsql-performance@postgresql.org
Message-ID: <1117790343.4380.89.camel@fandelm.ecommit.de>
In-Reply-To: <42A01E80.2030507@paradise.net.nz>
References: <1117201312.7060.6.camel@fandelm.ecommit.de>
References: <1117788544.4380.79.camel@fandelm.ecommit.de>
References: <42A01E80.2030507@paradise.net.nz>
Subject: Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)
x-scalix-Hops: 1
X-Mailer: Evolution 2.0.1 
Mime-Version: 1.0
Content-Type: text/plain
Content-Disposition: inline
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.032 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200506/65
X-Sequence-Number: 12703

ok i set it to 524288. ;)

Am Freitag, den 03.06.2005, 21:10 +1200 schrieb Mark Kirkwood:
> 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
>