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.
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 |