Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 0A37965056E
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat, 12 Jul 2008 09:04:11 -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 25470-01 for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat, 12 Jul 2008 09:03:53 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web56405.mail.re3.yahoo.com (web56405.mail.re3.yahoo.com
	[216.252.111.84])
	by postgresql.org (Postfix) with SMTP id B7B6765031C
	for <pgsql-admin@postgresql.org>; Sat, 12 Jul 2008 09:03:48 -0300 (ADT)
Received: (qmail 58042 invoked by uid 60001); 12 Jul 2008 12:03:47 -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=f3qhMTKapU7/o9A/cB1OJM4jb92szqYwIuqa9ZpynVaA34alczalZsv1MMJRNpChbNBdfF1XhlotY6fHRizdqGd30IKiLVaukL3aMWfchnyq0hlo3UEgGahpwlEcJX/DD3vGmKYJpvY4RNJRpaw6RsVWK81mdou9UCfydDQQkyc=;
Received: from [98.166.112.215] by web56405.mail.re3.yahoo.com via HTTP;
	Sat, 12 Jul 2008 05:03:46 PDT
X-Mailer: YahooMailRC/1042.40 YahooMailWebService/0.7.218
Date: Sat, 12 Jul 2008 05:03:46 -0700 (PDT)
From: Jessica Richard <rjessil@yahoo.com>
Subject: best starting points....
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-38738388-1215864226=:57936"
Message-ID: <202919.57936.qm@web56405.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/117
X-Sequence-Number: 29727

--0-38738388-1215864226=:57936
Content-Type: text/plain; charset=us-ascii

On a new system with 64G memory, what is the best starting points for
shmmax on OS and shared_buffers for Postgres. All databases combined
are about 50G.

I want to evaluate this with the two following scenarios:

1. this machine is running only  Postgres, no other applications

2. this machine has postgres plus some other things (such as web server, etc).

What are the dangers for shmmax and shared_buffers to be confiugred very big for each of the two scenarios?

In case #1, if shmmax = 63G and shared_buffers = 50G, can it speed up Postgres (loading almost all dbs into memeory)? 

Thanks,
Jessica


      
--0-38738388-1215864226=:57936
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 new system with 64G memory, what is the best starting points for
shmmax on OS and shared_buffers for Postgres. All databases combined
are about 50G.<br>
<br>
I want to evaluate this with the two following scenarios:<br>
<br>
1. this machine is running only&nbsp; Postgres, no other applications<br>
<br>
2. this machine has postgres plus some other things (such as web server, etc).<br>
<br>
What are the dangers for shmmax and shared_buffers to be confiugred very big for each of the two scenarios?<br>
<br>
In case #1, if shmmax = 63G and shared_buffers = 50G, can it speed up Postgres (loading almost all dbs into memeory)? <br>
<br>
Thanks,<br>
Jessica</div></div><br>

      </body></html>
--0-38738388-1215864226=:57936--