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

Поиск
Список
Период
Сортировка
От Aidan Van Dyk
Тема Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Дата
Msg-id CAC_2qU9bZNZSGMMWJ+6XBMKBJze2EKS8Zu-rb8Mxz36ngna0vA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL  (Pietro Pugni <pietro.pugni@gmail.com>)
Ответы Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: didier
Дата:
Сообщение: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Следующее
От: Pietro Pugni
Дата:
Сообщение: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL