Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Krupka
Subject Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Date
Msg-id CAB6McgWJYjXEWtycB0bo9G+abvE1nkhh259x4AZjOdutpGCfVw@mail.gmail.com
Whole thread Raw
In response to Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL  (Pietro Pugni <pietro.pugni@gmail.com>)
Responses Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL  (Pietro Pugni <pietro.pugni@gmail.com>)
List pgsql-performance
Tree view

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.

pgsql-performance by date:

Previous
From: Pietro Pugni
Date:
Subject: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Next
From: Pietro Pugni
Date:
Subject: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL