From: Shaun Thomas <sthomas@optionshouse.com>
To: Claudio Freire <klaussfreire@gmail.com>
Cc: Franklin, Dan (FEN) <Dan.Franklin@pearson.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Tons of free RAM. Can't make it go away.
Date: Tue, 23 Oct 2012 11:49:00 -0500
Message-ID: <5086CA7C.5080207@optionshouse.com> (raw)
In-Reply-To: <CAGTBQpY+qNJ7N9tcPTe-OQqtAwmSD6ov+DETXJ8-fB4nfHv6VQ@mail.gmail.com>
References: <508583E4.8080102@optionshouse.com>
<CAGTBQpZA+_fL=D_E0F8jmpdTcTePgkSQGMFEtoWN7OyWuDnOeQ@mail.gmail.com>
<5085873D.60400@optionshouse.com>
<CAGTBQpZt76_VwcSAXUSZWRu9c=E4V4mgVA9Y8a-d0cY+ycaYfQ@mail.gmail.com>
<508589F8.7020808@optionshouse.com>
<CAGTBQpZ-+zxkZfkyKr7ZZdfGC6D2FunrZBx3yo4kOwAiD1fzdg@mail.gmail.com>
<5C92D015D36C6248AFA3806E72C04A06067B7320@usoldt-e3mb-008.PEROOT.COM>
<50858F7B.4040802@optionshouse.com>
<CAGTBQpY+qNJ7N9tcPTe-OQqtAwmSD6ov+DETXJ8-fB4nfHv6VQ@mail.gmail.com>
On 10/22/2012 01:44 PM, Claudio Freire wrote:
> I think, unless it gives you trouble with the page cache, numactl
> --prefer=+0 should work nicely for postgres overall. Failing that,
> numactl --interleave=all would, IMO, be better than the system
> default.
Thanks, I'll consider that.
FWIW, our current stage cluster node is *not* doing this at all. In
fact, here's a numastat from stage:
node0 node1
numa_hit 1623243097 1558610594
numa_miss 257459057 310098727
numa_foreign 310098727 257459057
interleave_hit 25822175 26010606
local_node 1616379287 1545600377
other_node 264322867 323108944
Then from prod:
node0 node1
numa_hit 4987625178 3695967931
numa_miss 1678204346 418284176
numa_foreign 418284176 1678204370
interleave_hit 27578 27720
local_node 4988131216 3696305260
other_node 1677698308 417946847
Note how ridiculously uneven node0 and node1 are in comparison to what
we're seeing in stage. I'm willing to bet something is just plain wrong
with our current production node. So I'm working with our NOC team to
schedule a failover to the alternate node. If that resolves it, I'll see
if I can't get some kind of answer from our infrastructure guys to share
in case someone else encounters this.
Yes, even if that answer is "reboot." :)
Thanks again!
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sthomas@optionshouse.com, klaussfreire@gmail.com, Dan.Franklin@pearson.com
Subject: Re: Tons of free RAM. Can't make it go away.
In-Reply-To: <5086CA7C.5080207@optionshouse.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox