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 2BA65D1B4FD for ; Tue, 21 Oct 2003 13:32:09 +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 71394-01 for ; Tue, 21 Oct 2003 10:31:40 -0300 (ADT) Received: from twix.hotpop.com (twix.hotpop.com [204.57.55.70]) by svr1.postgresql.org (Postfix) with ESMTP id 6C294D1B554 for ; Tue, 21 Oct 2003 10:31:36 -0300 (ADT) Received: from hotpop.com (kubrick.hotpop.com [204.57.55.16]) by twix.hotpop.com (Postfix) with SMTP id 34B198D8770 for ; Tue, 21 Oct 2003 13:31:31 +0000 (UTC) Received: from hotpop.com (unknown [211.24.32.70]) by smtp-3.hotpop.com (Postfix) with ESMTP id BED448D5C45; Tue, 21 Oct 2003 13:31:22 +0000 (UTC) Message-ID: <3F953545.2000302@hotpop.com> Date: Tue, 21 Oct 2003 21:31:49 +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: "scott.marlowe" Cc: "'pgsql-admin@postgresql.org'" Subject: Re: Postgresql Memory Problem References: In-Reply-To: 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/255 X-Sequence-Number: 10816 scott.marlowe wrote: >On Mon, 20 Oct 2003, dotaku wrote: > > > >>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.. >> >> > >Are you talking about something like this: > >Mem: 1543980K av, 1538248K used, 5732K free, 266768K shrd, 36064K buff >Swap: 2048208K av, 194532K used, 1853676K free 802612K cached > >Where I'm only showing 5732k free, but 802612k cached? That's normal. >The linux kernel is just using the spare memory for file caching until >something tries to allocate a big chunk of memory, then it will give it >back. That's normal operation. > >Or is it something else? > > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > > Thanks...but can I flush a postgreql server unused memory after stopping it. The problem that i had is that, even after stopping all postgresql services...the used memory is still more than 80% of the total RAM.. any idea how to flush it. I've read somewhere about kflushd and bdflushd. How to used it...Both are kernel related. Is there any user space program that can kick it. --azman---