Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 9C627650332
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 10 Jul 2008 07:54:28 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 12903-01-8
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 10 Jul 2008 07:54:11 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web56404.mail.re3.yahoo.com (web56404.mail.re3.yahoo.com
	[216.252.111.83])
	by postgresql.org (Postfix) with SMTP id 095666508E2
	for <pgsql-performance@postgresql.org>;
	Thu, 10 Jul 2008 07:53:43 -0300 (ADT)
Received: (qmail 44963 invoked by uid 60001); 10 Jul 2008 10:53:40 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=jT1uTQQcqioiV91Ea5f5smTZs6u4nbamOkq46WQzNyGAYZkIucMWMgUTJFeoSwsvDk/LwuR+613VWGsOI5scftUust43ACVtEtrVKL479C+Gtr8sPXJE3EyqouHyoegTHJaa0QHZUcZ2IRIYZsPrWonGJZkLLmriLZ5dWxFr1Zk=;
Received: from [98.166.112.215] by web56404.mail.re3.yahoo.com via HTTP;
	Thu, 10 Jul 2008 03:53:40 PDT
X-Mailer: YahooMailRC/1042.40 YahooMailWebService/0.7.218
Date: Thu, 10 Jul 2008 03:53:40 -0700 (PDT)
From: Jessica Richard <rjessil@yahoo.com>
Subject: how big shmmax is good for Postgres...
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-941823993-1215687220=:44246"
Message-ID: <639285.44246.qm@web56404.mail.re3.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200807/88
X-Sequence-Number: 30688

--0-941823993-1215687220=:44246
Content-Type: text/plain; charset=us-ascii

On a Linux system,  if the total memory is 4G and the shmmax is set to 4G, I know it is bad, but how bad can it be? Just trying to understand the impact the "shmmax" parameter can have  on Postgres  and the entire system after Postgres comes up on this number.

What is the reasonable setting for shmmax on a 4G total machine?

Thanks a lot,
Jessica



      
--0-941823993-1215687220=:44246
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>On a Linux system,&nbsp; if the total memory is 4G and the shmmax is set to 4G, I know it is bad, but how bad can it be? Just trying to understand the impact the "shmmax" parameter can have&nbsp; on Postgres&nbsp; and the entire system after Postgres comes up on this number.<br><br>What is the reasonable setting for shmmax on a 4G total machine?<br><br>Thanks a lot,<br>Jessica <br></div></div><br>

      </body></html>
--0-941823993-1215687220=:44246--