Re: Low values for cached size

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Low values for cached size
Date: 2009-09-25 22:48:13
Message-ID: dcc563d10909251548j2ca0dc07r1827e81e3bef17cc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 25, 2009 at 3:28 PM, Carlos Henrique Reimer
<carlos(dot)reimer(at)opendb(dot)com(dot)br> wrote:
> Hi,
>
> We're facing performance problems in a Linux box running CentOS release 5
> (Final) and PostgreSQL 8.2.4. I've done some basic checks in the
> configuration but everything looks fine to me. One weird behaviour I've
> found is the cached size showed by the
> "top" and "free" Linux commands:
>
> top - 08:32:17 up 3 days, 19:04,  1 user,  load average: 1.09, 1.07, 1.10
> Tasks: 173 total,   2 running, 170 sleeping,   0 stopped,   1 zombie
> Cpu(s):  9.5%us,  0.5%sy,  0.0%ni, 88.2%id,  1.7%wa,  0.0%hi,  0.0%si,
> 0.0%st
> Mem:   3631900k total,  3378056k used,   253844k free,    25488k buffers
> Swap:  4192956k total,      100k used,  4192856k free,  2356588k cached
>
> [postgres(at)server01 etc]$ free
>              total       used       free     shared    buffers     cached
> Mem:       3631900    3174804     457096          0      14280    2086184
> -/+ buffers/cache:    1074340    2557560
> Swap:      4192956        108    4192848
> [postgres(at)server01 etc]$
>
> Both commands show values ranging from 2GB to 2.3GB for the cached size and
> the server has 3.5GB RAM. I do usally see  cached values with sizes bearing
> the size of the RAM in other servers. It seams that something is consuming
> the RAM and not letting it free to be used as cache for Linux files, right?
> The shared_buffers (256MB) is not high and I can not see a reason for this.
> Initially I've thought the problem was
> because the system was running with runlevel 5, but now, it's running with
> runlevel 3 and even so the values for
> cached size does not change.
>
> Any suggestions or directions I could follow to discover the reason?

If you run top, then hit M, and post the first 20 or so rows after
what you have here I can take a guess.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2009-09-25 23:35:24 Re: generic modelling of data models; enforcing constraints dynamically...
Previous Message Alvaro Herrera 2009-09-25 22:41:29 Re: lazy vacuum and AccessExclusiveLock