Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 2FC222E0062
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Thu,  3 Apr 2008 07:11:12 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 74830-04
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Thu,  3 Apr 2008 07:10:58 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.251])
	by developer.postgresql.org (Postfix) with ESMTP id A410F2E0056
	for <pgsql-performance@postgresql.org>;
	Thu,  3 Apr 2008 07:10:58 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c36so784656ana.33
	for <pgsql-performance@postgresql.org>;
	Thu, 03 Apr 2008 03:10:57 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=DpEnjivvcrk6al9iQ1KK3AumFalghstz5oTXFKy9dN8=;
	b=uucdBB1PXFxFBSN62jUfRRCuequhJEMYbo3CJTK9VbWMkLR595uCXr9Pes9BDbP9dSoafUZQ6AggMQvMA6cLnH0iYE0eQWyI/ADWIks4ungX5kDKOkWV/x6+m0Tvf1DtQEbmtxCltmuxP77TNDGxu+ncBl+5lvpd6jwlArlBqjk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=H0VdhdIZk8dr7a/XDR3RkFD+mNuA1rznlpe4xilnNPQcBFkqEq+xx6xericEN4eUFIJfKi5FWgUzDDVIBPe6h5Zz2j8pubHd0DZRIp7TkhIMy5Wu5Sab7alhKhfF7nDSANR+AjkKo0lsrEJncZun1VNvXUKMkhdK+n6DPT7Idq4=
Received: by 10.100.133.20 with SMTP id g20mr9884805and.2.1207217457529;
	Thu, 03 Apr 2008 03:10:57 -0700 (PDT)
Received: by 10.100.105.20 with HTTP; Thu, 3 Apr 2008 03:10:57 -0700 (PDT)
Message-ID: <f966c2ee0804030310w3581a17byb2f46f9b276d11b@mail.gmail.com>
Date: Thu, 3 Apr 2008 15:40:57 +0530
From: "sathiya psql" <sathiya.psql@gmail.com>
To: bitaoxiao <bitaoxiao@gmail.com>
Subject: Re: Max shared_buffers
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
In-Reply-To: <200804031256103599734@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1163_1427863.1207217457527"
References: <47F324B4.6010404@mansionfamily.plus.com>
	<b42b73150804022136y23e320e7w86540f2264aad33e@mail.gmail.com>
	<200804031256103599734@gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/30
X-Sequence-Number: 29523

------=_Part_1163_1427863.1207217457527
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

There is NO MAX....

It is according to your hardware you have, and the db you have.

2008/4/3 bitaoxiao <bitaoxiao@gmail.com>:

>
> What can be set as max of postgreSQL shared_buffers and work_mem
>
> 2008-04-03
> ------------------------------
>  bitaoxiao
>
>

------=_Part_1163_1427863.1207217457527
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

There is NO MAX....<br><br>It is according to your hardware you have, and the db you have.<br><br><div class="gmail_quote">2008/4/3 bitaoxiao &lt;<a href="mailto:bitaoxiao@gmail.com">bitaoxiao@gmail.com</a>&gt;:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">






<div style="margin: 10px; font-size: 10pt; font-family: verdana;">
<div><font color="#000080" face="Verdana" size="2"></font>&nbsp;</div>
<div><font color="#000080" face="Verdana" size="2">What can be set as max 
of&nbsp;postgreSQL shared_buffers and work_mem</font></div>
<div><font color="#000080" face="Verdana" size="2"></font>&nbsp;</div>
<div><font color="#c0c0c0" face="Verdana" size="2">2008-04-03 </font></div><font color="#000080" face="Verdana" size="2">
<hr style="width: 100px;" align="left" color="#b5c4df" size="1">
</font>
<div><font color="#c0c0c0" face="Verdana" size="2"><span>bitaoxiao</span> 
</font></div>
<div><font face="Verdana" size="2">
<div>&nbsp;</div></font></div></div>
</blockquote></div><br>

------=_Part_1163_1427863.1207217457527--