Re: Free memory usage Sol10, 8.2.9

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Free memory usage Sol10, 8.2.9
Date: 2009-11-04 10:35:23
Message-ID: hcrld7$4r1$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jeremy Harris wrote:
> 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(at)prod1 # prtconf
>> System Configuration: Sun Microsystems sun4u
>> Memory size: 32768 Megabytes
>>
>> [postgres(at)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.

To finish the thought: memory used by OS for caching files will be
automatically given to applications that need more memory so it is "kind
of" free memory.

In your case, you really do have 17-18G unused memory which is
practically wasted.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2009-11-04 13:59:25 Re: High Frequency Inserts to Postgres Database vs Writing to a File
Previous Message Tom Lane 2009-11-04 05:31:26 Re: maintaining a reference to a fetched row