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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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