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

From: Aidan Van Dyk <aidan(at)highrise(dot)ca>
To: Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com>
Cc: 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-02 12:51:14
Message-ID: CAC_2qU9bZNZSGMMWJ+6XBMKBJze2EKS8Zu-rb8Mxz36ngna0vA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Apr 2, 2015 at 6:33 AM, Pietro Pugni <pietro(dot)pugni(at)gmail(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pietro Pugni 2015-04-02 13:23:37 Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Previous Message didier 2015-04-02 12:29:09 Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL