Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 54B3863431B for ; Tue, 3 Nov 2009 16:43:12 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 94939-05 for ; Tue, 3 Nov 2009 20:42:58 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from wizmail.org (wizmail.org [217.146.107.12]) by mail.postgresql.org (Postfix) with ESMTP id BA27F6342A8 for ; Tue, 3 Nov 2009 16:43:01 -0400 (AST) Received: from ebony.jgh.adsl.wizards.co.uk ([217.146.123.59]) (from_AS 16353) by wizmail.org with esmtpsa (TLSv1:DHE-RSA-CAMELLIA256-SHA:256) (Exim 4.69) id 1N5QDT-0006Lf-RK (return-path ); Tue, 03 Nov 2009 20:42:59 +0000 Message-ID: <4AF095D0.9000705@wizmail.org> Date: Tue, 03 Nov 2009 20:42:56 +0000 From: Jeremy Harris User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.21) Gecko/20090320 Fedora/2.0.0.21-1.fc9 Thunderbird/2.0.0.21 Mnenhy/0.7.5.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Free memory usage Sol10, 8.2.9 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200911/29 X-Sequence-Number: 36197 On 11/03/2009 07:16 PM, Subbiah Stalin-XCGF84 wrote: > All, > > I'm trying to understand the free memory usage and why it falls below > 17G sometimes and what could be causing it. Any pointers would be > appreciated. > > root@prod1 # prtconf > System Configuration: Sun Microsystems sun4u > Memory size: 32768 Megabytes > > [postgres@prod1 ~]$ vmstat 5 10 > kthr memory page disk faults > cpu > r b w swap free re mf pi po fr de sr 1m 1m 1m m1 in sy cs us > sy id > 0 0 0 51713480 21130304 58 185 325 104 104 0 0 23 3 7 1 488 604 573 1 > 2 97 > 0 0 0 51048768 18523456 6 10 0 192 192 0 0 4 0 3 0 527 753 807 2 > 1 97 Memory used by the OS for caching files is no longer free. Free memory is wasted memory. -J