Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B1BB737C874
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  6 Oct 2008 08:53:05 -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 43190-01 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  6 Oct 2008 08:53:02 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.153])
	by postgresql.org (Postfix) with ESMTP id 6A6B337C2C3
	for <pgsql-admin@postgresql.org>; Mon,  6 Oct 2008 08:53:02 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so2030197fgg.23
	for <pgsql-admin@postgresql.org>; Mon, 06 Oct 2008 04:52:59 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=5v/cdBZILEsH+T/5H1jK597UYNbjXhlLMtQhFfbkkqc=;
	b=tGPMU2ZIuvgUdAQOmf94VM0KOCO1ADpERnuhphrwlSveUFMLITSZV6TdeZLZy9TtjD
	xAg/1EXvI0AkUzEDzf6nMRuUSoI8+265Wo9bQ46jy7TZ/zcJMMiSTZsjNDywdI3nbPCn
	m5XIeDvPS7hU8ePYrk8uefUSa9kuikNHrpUp4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=KOBk9/I3N7KY9FYEljLboi2gTX0LF5vVA3xYCby7pltPwv36cTQI4AvtQVZ5IUwtOn
	wvOgln8SD4/3UTuwCBuHbCDc7Y3inKA0cO+ee+JGpsaxZmqpFi4ja6gxoSKblFyVmN6m
	1l78W1OmqTxhWYlpgvx+AE40mMKtnRABFhSk0=
Received: by 10.86.63.19 with SMTP id l19mr4471137fga.60.1223293979631;
	Mon, 06 Oct 2008 04:52:59 -0700 (PDT)
Received: by 10.86.71.17 with HTTP; Mon, 6 Oct 2008 04:52:59 -0700 (PDT)
Message-ID: <3a0028490810060452m268d0777uc18e2e605ff0bd28@mail.gmail.com>
Date: Mon, 6 Oct 2008 09:52:59 -0200
From: "Rafael Domiciano" <rafael.domiciano@gmail.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Shared_buffers hint
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_25074_18868574.1223293979622"
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: 200810/19
X-Sequence-Number: 30475

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

HI people,
I'm tuning a server that is a long time abandoned, and this server is a
little slow.
Now, in my postgresql.conf I have:
shared_buffers = 100Mb
mas_fsm_relations = 15000
mas_fsm_pages = 1600000
max_connections = 300

And I changin' to:
shared_buffers = 1000Mb
   (The server has 2 Gb of memory)
mas_fsm_relations = 15000
   (The Vacuum noticed me 608 relations)
mas_fsm_pages = 1600000
   (The Vacuum noticed me 500800 pages)
max_connections = 300
   (I did a "ps axf | grep postgres | wc -l" and the bash brings to me the
number of 120 and all the people is not online at now)

My qustion is about shared_buffers, in postgresql.conf I have: min 128kB or
max_connections*16kB  # (change requires restart)
So I did:
300 * (16Kb / 1024) = 4,69?
What this result means?

Thnks all,

Rafael Domiciano

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

<div dir="ltr">HI people,<div><br></div><div>I&#39;m tuning a server that is a long time abandoned, and this server is a little slow.</div><div>Now, in my postgresql.conf I have:</div><div>shared_buffers = 100Mb</div><div>
mas_fsm_relations = 15000</div><div>mas_fsm_pages = 1600000</div><div>max_connections = 300</div><div><br></div><div>And I changin&#39; to:</div><div><div>shared_buffers = 1000Mb</div><div><span class="Apple-style-span" style="font-weight: bold;">&nbsp;&nbsp; (The server has 2 Gb of memory)</span></div>
<div>mas_fsm_relations = 15000</div><div><span class="Apple-style-span" style="font-weight: bold;">&nbsp;&nbsp; (The Vacuum noticed me 608 relations)</span></div><div>mas_fsm_pages = 1600000</div><div><span class="Apple-style-span" style="font-weight: bold;">&nbsp;&nbsp; (The Vacuum noticed me&nbsp;500800 pages)</span></div>
<div>max_connections = 300</div><div><span class="Apple-style-span" style="font-weight: bold;">&nbsp;&nbsp; (I did a &quot;ps axf | grep postgres | wc -l&quot; and the bash brings to me the number of 120 and all the people is not online at now)</span></div>
<div><span class="Apple-style-span" style="font-weight: bold;"><br></span></div><div>My qustion is about<span class="Apple-style-span" style="font-weight: bold;"> shared_buffers</span>, in postgresql.conf I have:&nbsp;<span class="Apple-style-span" style="font-weight: bold; ">min 128kB or max_connections*16kB&nbsp;&nbsp;# (change requires restart)</span></div>
<div>So I did:</div><div>300 * (16Kb / 1024) = 4,69?</div><div>What this result means?</div><div><br></div><div>Thnks all,</div><div><br></div><div>Rafael Domiciano</div></div></div>

------=_Part_25074_18868574.1223293979622--