X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 05320310265 for ; Fri, 27 Jun 2003 20:17:19 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 34065-01 for ; Fri, 27 Jun 2003 17:17:08 -0300 (ADT) Received: from indygecko.com (h24-77-222-182.ok.shawcable.net [24.77.222.182]) by svr1.postgresql.org (Postfix) with ESMTP id 990DF31026F for ; Fri, 27 Jun 2003 17:17:07 -0300 (ADT) Received: from [192.168.10.10] ([::ffff:192.168.10.10]) by indygecko.com with esmtp; Fri, 27 Jun 2003 13:17:04 -0700 Subject: Re: Memory question From: Jord Tanner To: Patrick Hatcher , pgsql-performance@postgresql.org In-Reply-To: References: Organization: Message-Id: <1056745023.4726.50.camel@gecko> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 27 Jun 2003 13:17:04 -0700 X-Archive-Number: 200306/195 X-Sequence-Number: 2279 On Fri, 2003-06-27 at 12:09, Patrick Hatcher wrote: > 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. In my experience Linux likes to allocate almost all available RAM. I've never had any trouble with that. I'm looking at the memory meter on my RH9 development workstation and it is at 95%. Performance is good, so I just trust that the kernel knows what it is doing. > Mem: 6711564K av, 6517776K used, 193788K free, 0K shrd, 25168K > buff > Swap: 2044056K av, 0K used, 2044056K free 6257620K > cached I've heard anecdotally that Linux has troubles if the swap space is less than the RAM size. I note that you have 6G of RAM, but only 2G of swap. I'm sure others on the list will have more definitive opinions. -- Jord Tanner