Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 07FB11337BB4
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  5 Apr 2011 10:20:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 92501-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  5 Apr 2011 13:20:06 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp140.iad.emailsrvr.com (smtp140.iad.emailsrvr.com
	[207.97.245.140])
	by mail.postgresql.org (Postfix) with ESMTP id CEEDF1337B43
	for <pgsql-performance@postgresql.org>;
	Tue,  5 Apr 2011 10:20:05 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp54.relay.iad1a.emailsrvr.com (SMTP Server) with ESMTP id
	ED97F2B0D46; Tue,  5 Apr 2011 09:20:05 -0400 (EDT)
X-Virus-Scanned: OK
Received: by smtp54.relay.iad1a.emailsrvr.com (Authenticated sender:
	adarsh.sharma-AT-orkash.com) with ESMTPSA id E70F12B0D44;
	Tue,  5 Apr 2011 09:20:04 -0400 (EDT)
Message-ID: <4D9B1705.2030601@orkash.com>
Date: Tue, 05 Apr 2011 18:50:05 +0530
From: Adarsh Sharma <adarsh.sharma@orkash.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090625)
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Postgres Performance Tuning
References: <4D999211.9080507@orkash.com>
	<BANLkTi=ykDDwaAxphKH061Y2aZ1ygnmPEA@mail.gmail.com>
	<BANLkTinONdxh35_0rTdg1L7K=C1KimRUnA@mail.gmail.com>
	<BANLkTin1ss6Sy2PYtbvYPUjz0_A_Uxb5Fg@mail.gmail.com>
	<4D99ACC0.5090009@orkash.com>
	<BANLkTi=irsx4RauJoLbPDRLqy8-MCP7G7g@mail.gmail.com>
	<4D99B0B1.4020702@orkash.com>
	<BANLkTim-0q-FQxY8X3kruYuoeM=JDS2ADQ@mail.gmail.com>
	<4D9AC5B1.8080204@orkash.com>
	<BANLkTi=GhO3SaXgy7SweHHTO2zTGkLO23Q@mail.gmail.com>
In-Reply-To: <BANLkTi=GhO3SaXgy7SweHHTO2zTGkLO23Q@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------060703090104030104000507"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201104/29
X-Sequence-Number: 43091

This is a multi-part message in MIME format.
--------------060703090104030104000507
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Scott Marlowe wrote:
> On Tue, Apr 5, 2011 at 1:33 AM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
>   
>> [root@s8-mysd-2 ~]# free -m
>>            total       used       free     shared    buffers     cached
>> Mem:         15917      15826         90          0        101      15013
>> -/+ buffers/cache:        711      15205
>> Swap:        16394        143      16250
>>
>> It means 15 GB memory is cached.
>>     
>
> Note that the kernel takes all otherwise unused memory and uses it for
> cache.  If, at any time a process needs more memory, the kernel just
> dumps some cached data and frees up the memory and hands it over, it's
> all automatic.  As long as cache is large, things are OK.  You need to
> be looking to see if you're IO bound or CPU bound first.  so, vmstat
> (install the sysstat package) is the first thing to use.
>   
Thanks a lot , Scott. :-)



Best Regards , Adarsh



--------------060703090104030104000507
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Scott Marlowe wrote:
<blockquote
 cite="mid:BANLkTi=GhO3SaXgy7SweHHTO2zTGkLO23Q@mail.gmail.com"
 type="cite">
  <pre wrap="">On Tue, Apr 5, 2011 at 1:33 AM, Adarsh Sharma <a class="moz-txt-link-rfc2396E" href="mailto:adarsh.sharma@orkash.com">&lt;adarsh.sharma@orkash.com&gt;</a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">[root@s8-mysd-2 ~]# free -m
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;total &nbsp; &nbsp; &nbsp; used &nbsp; &nbsp; &nbsp; free &nbsp; &nbsp; shared &nbsp; &nbsp;buffers &nbsp; &nbsp; cached
Mem: &nbsp; &nbsp; &nbsp; &nbsp; 15917 &nbsp; &nbsp; &nbsp;15826 &nbsp; &nbsp; &nbsp; &nbsp; 90 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp;101 &nbsp; &nbsp; &nbsp;15013
-/+ buffers/cache: &nbsp; &nbsp; &nbsp; &nbsp;711 &nbsp; &nbsp; &nbsp;15205
Swap: &nbsp; &nbsp; &nbsp; &nbsp;16394 &nbsp; &nbsp; &nbsp; &nbsp;143 &nbsp; &nbsp; &nbsp;16250

It means 15 GB memory is cached.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Note that the kernel takes all otherwise unused memory and uses it for
cache.  If, at any time a process needs more memory, the kernel just
dumps some cached data and frees up the memory and hands it over, it's
all automatic.  As long as cache is large, things are OK.  You need to
be looking to see if you're IO bound or CPU bound first.  so, vmstat
(install the sysstat package) is the first thing to use.
  </pre>
</blockquote>
Thanks a lot , Scott.<span class="moz-smiley-s1"><span> :-) </span></span><br>
<br>
<br>
<br>
Best Regards , Adarsh<br>
<br>
<br>
</body>
</html>

--------------060703090104030104000507--