Re: Tons of free RAM. Can't make it go away.

This is a good general discussion of the problem - looks like you could
replace "MySQL" with "PostgreSQL" everywhere without loss of generality:

http://blog.jcole.us/2010/09/28/mysql-swap-insanity-and-the-numa-archite
cture/

Dan

-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Claudio
Freire
Sent: Monday, October 22, 2012 2:14 PM
To: sthomas(at)optionshouse(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Tons of free RAM. Can't make it go away.

On Mon, Oct 22, 2012 at 3:01 PM, Shaun Thomas <sthomas(at)optionshouse(dot)com>
wrote:
>
>> Did you check the kernel's zone_reclaim_mode ?
>
>
> It's currently set to 0, which as I'm led to believe, is the setting I
want
> there.

Yep

> But here's something interesting:
>
> numactl --hardware
>
> available: 2 nodes (0-1)
> node 0 cpus: 0 2 4 6 8 10 12 14 16 18 20 22
> node 0 size: 36853 MB
> node 0 free: 13816 MB
> node 1 cpus: 1 3 5 7 9 11 13 15 17 19 21 23
> node 1 size: 36863 MB
> node 1 free: 751 MB
> node distances:
> node 0 1
> 0: 10 20
> 1: 20 10
>
>
> Looks like CPU 0 is hoarding memory. :(

You may want to try setting the numa policy before launching postgres:

numactl --interleave=all pg_ctl start

or

numactl --preferred=+0 pg_ctl start

--
Sent via pgsql-performance mailing list
(pgsql-performance(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance