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 Aidan Van Dyk
Subject Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Date
Msg-id CAC_2qU9bZNZSGMMWJ+6XBMKBJze2EKS8Zu-rb8Mxz36ngna0vA@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
On Thu, Apr 2, 2015 at 6:33 AM, Pietro Pugni <pietro.pugni@gmail.com> wrote:
 
T420
work_mem = 512MB
 
MacMini
work_mem = 32MB

So that is why the T420 does memory sorts and the mini does disk sorts.

I'd start looking at why memory sorts on the T420 is so slow.   Check your numa settings, etc (as already mentioned).

For a drastic test, disable the 2nd socket on the dell, and just use one (eliminate any numa/QPI costs) and see how it compares to the no-numa MacMini.

If you want to see how bad the NUMA/QPI is, play with stream to benchmark memory performance.

a.

pgsql-performance by date:

Previous
From: didier
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