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

2017-08-25 Thread Felix Geisendörfer
ort benefit so massively from the advancement here (~10x), but Seq Scan, Unique and HashAggregate don't benefit as much (~2x)? As you can probably tell, my hardware knowledge is very superficial, so I apologize if this is a stupid question. But I'd genuinely like to improve my understanding and

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

2017-08-27 Thread Felix Geisendörfer
> On Aug 25, 2017, at 17:07, Tom Lane wrote: > > =?utf-8?Q?Felix_Geisend=C3=B6rfer?= writes: >> I recently came across a performance difference between two machines that >> surprised me: >> ... >> As you can see, Machine A spends 5889ms on the Sort Node vs 609ms on Machine >> B when looking a