Skip site navigation (1) Skip section navigation (2)

Re: Memory question

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: scott(dot)marlowe(at)ihs(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Memory question
Date: 2003-06-27 19:59:23
Message-ID: OFF9755952.AD6D7C3D-ON88256D52.006DC794-88256D52.006E50C8@fds.com (view raw or flat)
Thread:
Lists: pgsql-performance
Thank you

Patrick Hatcher



                                                                                                                                       
                    "scott.marlowe                                                                                                     
                    "                    To:     Patrick Hatcher <PHatcher(at)macys(dot)com>                                                  
                    <scott.marlowe       cc:     <pgsql-performance(at)postgresql(dot)org>                                                    
                    @ihs.com>            Subject:     Re: [PERFORM] Memory question                                                    
                                                                                                                                       
                    06/27/2003                                                                                                         
                    12:44 PM                                                                                                           
                                                                                                                                       




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
>





In response to

pgsql-performance by date

Next:From: Jord TannerDate: 2003-06-27 20:17:04
Subject: Re: Memory question
Previous:From: Patrick HatcherDate: 2003-06-27 19:58:22
Subject: Re: Memory question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group