| From: | Josh Krupka <jkrupka(at)gmail(dot)com> |
|---|---|
| To: | Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com> |
| Cc: | Aidan Van Dyk <aidan(at)highrise(dot)ca>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |
| Date: | 2015-04-03 15:00:09 |
| Message-ID: | CAB6McgWJYjXEWtycB0bo9G+abvE1nkhh259x4AZjOdutpGCfVw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pietro Pugni | 2015-04-03 15:10:47 | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |
| Previous Message | Pietro Pugni | 2015-04-03 13:55:04 | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |