X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1DAA3D1B54E for ; Mon, 20 Oct 2003 09:05:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 78760-03 for ; Mon, 20 Oct 2003 06:04:41 -0300 (ADT) Received: from twix.hotpop.com (twix.hotpop.com [204.57.55.70]) by svr1.postgresql.org (Postfix) with ESMTP id EE627D1B50C for ; Mon, 20 Oct 2003 06:04:38 -0300 (ADT) Received: from hotpop.com (kubrick.hotpop.com [204.57.55.16]) by twix.hotpop.com (Postfix) with SMTP id 97D998CB9D5 for ; Mon, 20 Oct 2003 09:01:52 +0000 (UTC) Received: from hotpop.com (unknown [210.19.70.130]) by smtp-3.hotpop.com (Postfix) with ESMTP id ED6E38CB983 for ; Mon, 20 Oct 2003 09:01:49 +0000 (UTC) Message-ID: <3F93A474.7010102@hotpop.com> Date: Mon, 20 Oct 2003 17:01:40 +0800 From: dotaku Reply-To: dotaku@hotpop.com User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20031006 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Postgresql Memory Problem Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-HotPOP: ----------------------------------------------- Sent By HotPOP.com FREE Email Get your FREE POP email at www.HotPOP.com ----------------------------------------------- X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/226 X-Sequence-Number: 10787 Hi all.. i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9. When the memory usage reached 80% or more of the total memory in the system.. the memory just keep stuck there..The thing did not reduce bt itself... Then i decided to stop the postgresql service. But ...the memory that postgresql used still stuck...I used top to check the memory... The only way to solved it now...is via rebooting the machine..But that is ridiculous.. Need Help....maybe i miss configured the postgresql.conf. But give me something to tinker with.. thank in advanced... --azman--