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

From Peter Geoghegan
Subject Re: [PERFORM] 10x faster sort performance on Skylake CPU vs Ivy Bridge
Date
Msg-id CAH2-WznaO1jsm1MsnpwAp4PArxP9NDhV-zHMgTy8sG6_OMwN7A@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] 10x faster sort performance on Skylake CPU vs Ivy Bridge  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Aniko Belim
Date:
Subject: [PERFORM] Partitioned table - scans through every partitions
Next
From: Justin Pryzby
Date:
Subject: Re: [PERFORM] Partitioned table - scans through every partitions