Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: "Patrick Hatcher" <PHatcher@macys.com>,
	pgsql-performance@postgresql.org
Subject: Re: Memory question
Date: Fri, 27 Jun 2003 12:54:51 -0700
User-Agent: KMail/1.4.3
References: 
 <OFDDA6A696.3FAB98BA-ON88256D52.006707EF-88256D52.0069C75F@fds.com>
In-Reply-To: 
 <OFDDA6A696.3FAB98BA-ON88256D52.006707EF-88256D52.0069C75F@fds.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200306271254.51441.josh@agliodbs.com>

Patrick,

> 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.

What's you shared_buffers set to after our talk?  Do you actually need 3gb =
of=20
shmmax?=20=20

> 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?

No.=20=20=20

> Mem:  6711564K av, 6517776K used,  193788K free,       0K shrd,   25168K

The "used" figure in Top doesn't really tell you anything, since it include=
s=20
the kernel buffer which tries to take up all available memory.  If you=20
actually look at the list of processes, I think you'll find that you're onl=
y=20
using 1-2% of memory for applications.

I'm not sure what app would show your "real" free memory.

--=20
-Josh Berkus
 Aglio Database Solutions
 San Francisco