Re: Urgent -- Very HIGH memory usage on PostgreSQL server - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Urgent -- Very HIGH memory usage on PostgreSQL server
Date
Msg-id AANLkTi=Ni01GNQ0k-bbRcfTVjdp-Y=fKcPAt3-Hf7m9M@mail.gmail.com
Whole thread Raw
In response to Urgent -- Very HIGH memory usage on PostgreSQL server  (savio rodriges <sj_savio@yahoo.com>)
List pgsql-admin
On Sun, Dec 12, 2010 at 9:39 AM, savio rodriges <sj_savio@yahoo.com> wrote:
> Hello Support,
>
> We are facing very HIGH memory utilization on postgreSQL server and need help.
>
> Below are details of PostgreSQL server,
>
> ===========================================================================
> MemTotal:      8165696 kB
> CpuTotal:      8
> ===========================================================================
> /etc/sysctl.conf
> ----------------
> # Controls the maximum shared segment size, in bytes
> kernel.shmmax = 68719476736
>
> # Controls the maximum number of shared memory segments, in pages
> kernel.shmall = 4294967296
> ===========================================================================
> top - 21:43:35 up 55 days,  8:07,  4 users,  load average: 0.05, 0.25, 0.17
> Tasks: 257 total,   1 running, 256 sleeping,   0 stopped,   0 zombie
> Cpu(s):  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
> Mem:   8165696k total,  7943160k used,   222536k free,   282044k buffers
> Swap:  8385920k total,   112828k used,  8273092k free,  4793732k cached

This looks completely normal to me.  You're using about 4.7G for
kernel cache, and 282M for buffers.

pgsql-admin by date:

Previous
From: David Underhill
Date:
Subject: Re: FOR SHARE permissions
Next
From: Gerhard Hintermayer
Date:
Subject: Re: Two copies of Postgres with Graphical installer