Re: free RAM not being used for page cache

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Kevin Goess <kgoess(at)bepress(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: free RAM not being used for page cache
Date: 2014-07-30 19:07:12
Message-ID: CAOR=d=3kngqVp0TRvbvWMaHg+NATLb9PWvkwo3mdwcRBp5sC=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 30, 2014 at 12:57 PM, Kevin Goess <kgoess(at)bepress(dot)com> wrote:
> On Wed, Jul 30, 2014 at 11:49 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>> On Wed, Jul 30, 2014 at 12:51 PM, Kevin Goess <kgoess(at)bepress(dot)com> wrote:
>> > A couple months ago we upgraded the RAM on our database servers from
>> > 48GB to
>> > 64GB. Immediately afterwards the new RAM was being used for page cache,
>> > which is what we want, but that seems to have dropped off over time, and
>> > there's currently actually like 12GB of totally unused RAM.
>> >
>> >
>> > http://s76.photobucket.com/user/kgoesspb/media/db1-mem-historical.png.html
>> >
>> > Is that expected? Is there a setting we need to tune for that? We have
>> > 400GB of databases on this box, so I know it's not all fitting in that
>> > 49.89GB.
>>
>> could be a numa issue. Take a look at:
>>
>> http://frosty-postgres.blogspot.com/2012/08/postgresql-numa-and-zone-reclaim-mode.html
>>
>> merlin
> Good suggestion, but nope, that ain't it:
>
> $ cat /proc/sys/vm/zone_reclaim_mode
> 0

Could it just be your dataset isn't any bigger than what's being used?
--
To understand recursion, one must first understand recursion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Seref Arikan 2014-07-30 19:08:08 Re: How can I create null value from function call with no results?
Previous Message Kevin Grittner 2014-07-30 19:05:18 Re: free RAM not being used for page cache