Re: Memory question - Mailing list pgsql-performance

From scott.marlowe
Subject Re: Memory question
Date
Msg-id Pine.LNX.4.33.0306271341590.964-100000@css120.ihs.com
Whole thread Raw
In response to Memory question  ("Patrick Hatcher" <PHatcher@macys.com>)
Responses Re: Memory question  ("Patrick Hatcher" <PHatcher@macys.com>)
Re: Memory question  (Jonathan Gardner <jgardner@jonathangardner.net>)
List pgsql-performance
This is actually normal.  Look at the amount cached: 6257620K.  That's
6.2Gig of cache.  Linux is using only 6517776k - 6257620k of memory, the
rest is just acting as kernel cache.  If anything tries to allocate a bit
of memory, linux will flush enough cache to give the memory to the
application that needs it.

Note that you're only showing linux and all its applications using about
256Meg.

On Fri, 27 Jun 2003, Patrick Hatcher wrote:

> Sorry for posting an obvious Linux question, but have any of you
> encountered this and how have you fixed it.
> I have 6gig Ram box.  I've set my shmmax  to 3072000000.  The database
> starts up fine without any issues.  As soon as a query is ran
> or a FTP process to the server  is done, the used memory shoots up and
> appears to never be released.
> My fear is that this may cause problems for my database if this number
> continues to grow.  Below is my TOP after running a query, and shutting
> down PgAdmin.  While not low now, the amount of free memory has dropped to
> around 11mg.  I'll admit I'm not that Linux savvy, but am I reading this
> correct?
>
> --TOP
>
> 45 processes: 44 sleeping, 1 running, 0 zombie, 0 stopped
> CPU0 states:  0.0% user,  0.0% system,  0.0% nice, 100.0% idle
> CPU1 states:  0.0% user,  0.0% system,  0.0% nice, 100.0% idle
> CPU2 states:  0.0% user,  0.0% system,  0.0% nice, 100.0% idle
> CPU3 states:  0.0% user,  0.0% system,  0.0% nice, 100.0% idle
> Mem:  6711564K av, 6517776K used,  193788K free,       0K shrd,   25168K
> buff
> Swap: 2044056K av,       0K used, 2044056K free                 6257620K
> cached
>
> Patrick Hatcher
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


pgsql-performance by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Memory question
Next
From: Josh Berkus
Date:
Subject: Re: Memory question