pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adarsh Sharma <adarsh.sharma@orkash.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres Performance Tuning
Date: Tue, 05 Apr 2011 18:50:05 +0530
Message-ID: <4D9B1705.2030601@orkash.com> (raw)
In-Reply-To: <BANLkTi=GhO3SaXgy7SweHHTO2zTGkLO23Q@mail.gmail.com>
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>

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

view thread (22+ messages)  latest in thread

Message-ID: <4D9B1705.2030601@orkash.com>
Permalink:  ../4D9B1705.2030601@orkash.com/
Also on:    postgresql.org/message-id/4D9B1705.2030601@orkash.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: adarsh.sharma@orkash.com, scott.marlowe@gmail.com
  Subject: Re: Postgres Performance Tuning
  In-Reply-To: <4D9B1705.2030601@orkash.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox