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

Memory question

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Memory question
Date: 2003-06-27 19:09:50
Message-ID: OFDDA6A696.3FAB98BA-ON88256D52.006707EF-88256D52.0069C75F@fds.com (view raw or flat)
Thread:
Lists: pgsql-performance
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



Responses

pgsql-performance by date

Next:From: scott.marloweDate: 2003-06-27 19:44:38
Subject: Re: Memory question
Previous:From: Josh BerkusDate: 2003-06-27 15:41:40
Subject: Re: Large querie with several EXISTS which will be often runned

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