Re: free RAM not being used for page cache

From: Kevin Goess <kgoess(at)bepress(dot)com>
To: "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 18:57:43
Message-ID: CABZkbxiWd2Qtg4GeAQk7QP-FZA1infzwn3wAwkFe0K+yCshZWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Good suggestion, but nope, that ain't it:

$ cat /proc/sys/vm/zone_reclaim_mode
0

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
>

--
Kevin M. Goess
Software Engineer
Berkeley Electronic Press
kgoess(at)bepress(dot)com

510-665-1200 x179
www.bepress.com

bepress: sustainable scholarly publishing

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seref Arikan 2014-07-30 19:01:02 Re: How can I create null value from function call with no results?
Previous Message Tom Lane 2014-07-30 18:54:11 Re: How can I create null value from function call with no results?