Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL

[Josh Krupka <jkrupka@xxxxxxxxx>]

A more simple "overview" might be "numactl —hardware”

It returns the following output:

sh-4.3# numactl --hardware

available: 2 nodes (0-1)

node 0 cpus: 0 2 4 6 8 10 12 14 16 18 20 22 24 26 28 30

node 0 size: 64385 MB

node 0 free: 56487 MB

node 1 cpus: 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31

node 1 size: 64508 MB

node 1 free: 62201 MB

node distances:

node   0   1 

  0:  10  20 

  1:  20  10 

Did you already post the results of:
cat /proc/sys/vm/zone_reclaim_mode

Also, how big did you say your dataset is? Based on the output of free, you're certainly not using all the memory you have.  That could be just because you haven't accessed that much of your dataset, or it could be because zone reclaim is preventing you from using your entire amount of RAM as file system cache.