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@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of Claudio Freire Sent: Monday, October 22, 2012 2:14 PM To: sthomas@xxxxxxxxxxxxxxxx Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Tons of free RAM. Can't make it go away. On Mon, Oct 22, 2012 at 3:01 PM, Shaun Thomas <sthomas@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
