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 BA5819DCB9C for ; Tue, 6 Dec 2005 10:45:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20383-05 for ; Tue, 6 Dec 2005 10:46:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 620229DCBC4 for ; Tue, 6 Dec 2005 10:45:57 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jB6Ejxt5029917; Tue, 6 Dec 2005 09:45:59 -0500 (EST) To: Kathy Lo cc: pgsql-performance@postgresql.org Subject: Re: Memory Leakage Problem In-reply-to: References: Comments: In-reply-to Kathy Lo message dated "Tue, 06 Dec 2005 17:22:30 +0800" Date: Tue, 06 Dec 2005 09:45:59 -0500 Message-ID: <29916.1133880359@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.003 required=5 tests=[AWL=0.003] X-Spam-Score: 0.003 X-Spam-Level: X-Archive-Number: 200512/167 X-Sequence-Number: 15988 Kathy Lo writes: > I found that the memory of the databaser server nearly used up (total 2G RAM). > After I stop the program, the used memory did not free. I see no particular reason to believe that you are describing an actual memory leak. More likely, you are just seeing the kernel's normal behavior of eating up unused memory for disk cache space. Repeat after me: zero free memory is the normal and desirable condition on Unix-like systems. regards, tom lane