X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3C2DA11F6A9F for ; Fri, 21 Apr 2006 13:38:37 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 1.516 X-Spam-Level: * X-Spam-Status: No, score=1.516 required=5 tests=[AWL=-0.403, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id Os0zthFLvwJ3 for ; Fri, 21 Apr 2006 13:38:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by postgresql.org (Postfix) with ESMTP id 6096611F663F for ; Fri, 21 Apr 2006 13:38:31 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx2.surnet.cl with ESMTP; 21 Apr 2006 12:38:30 -0400 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AQAAAE6QIkSICgIC X-IronPort-AV: i="4.02,198,1139194800"; d="scan'208"; a="44814434:sNHT242835652" Received: from alvh.no-ip.org (200.126.99.223) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 443B7DDC00162F0C; Fri, 21 Apr 2006 12:38:30 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id E57F0C30F8E; Fri, 21 Apr 2006 12:38:29 -0400 (CLT) Date: Fri, 21 Apr 2006 12:38:29 -0400 From: Alvaro Herrera To: ALVARO ARCILA Cc: pgsql-performance@postgresql.org Subject: Re: Inactive memory Grows unlimited Message-ID: <20060421163829.GD7303@surnet.cl> Mail-Followup-To: ALVARO ARCILA , pgsql-performance@postgresql.org References: <007f01c6654b$15077280$8300a8c0@tridecap.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.11+cvs20060403 X-Archive-Number: 200604/506 X-Sequence-Number: 18590 ALVARO ARCILA wrote: > Hi, > > I hope you can help me...there's something wrong going on my db server (OS. > GNU/linux White box)... here's the problem... > > The amount of Inactive memory Grows unlimited .... this happens only when > Postgresql (8.1.1) is running... after a few days it "eats" all the RAM > memory ... so I've have to restart the server to free RAM.... This is normal Unix behavior. Leave it running for a few more days and you'll that nothing wrong happens. Why do you think you need "free" memory? Only if the swap memory start getting used a lot you need to worry about memory consumption. You should upgrade to 8.1.3 BTW. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.