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.
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 |