Re: [PERFORM] 10x faster sort performance on Skylake CPU vs Ivy Bridge

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: [PERFORM] 10x faster sort performance on Skylake CPU vs Ivy Bridge
Дата
Msg-id CAH2-WznaO1jsm1MsnpwAp4PArxP9NDhV-zHMgTy8sG6_OMwN7A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] 10x faster sort performance on Skylake CPU vs Ivy Bridge  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
On Fri, Aug 25, 2017 at 8:07 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I doubt this is a hardware issue, it's more likely that you're comparing
> apples and oranges.  The first theory that springs to mind is that the
> sort keys are strings and you're using C locale on the faster machine but
> some non-C locale on the slower.  strcoll() is pretty darn expensive
> compared to strcmp() :-(

strcoll() is very noticeably slower on macOS, too.

--
Peter Geoghegan

В списке pgsql-performance по дате отправления:

Предыдущее
От: Aniko Belim
Дата:
Сообщение: [PERFORM] Partitioned table - scans through every partitions
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: [PERFORM] Partitioned table - scans through every partitions