Re: [HACKERS] Questions about checksum feature in 9.3

2013-09-18 Thread Jim Nasby
On 9/16/13 10:14 AM, David Johnston wrote: The "single" core aspect is interesting. Does the implementation have a dedicated core to perform these calculations or must the same thread that handles the relevant query perform this work as well? How much additional impact/overhead does having to m

Re: [HACKERS] Questions about checksum feature in 9.3

2013-09-16 Thread David Johnston
Ants Aasma-2 wrote >> So, has anyone compiled checksum vectorized on OS X? Are there any >> performance data that would indicate whether or not I should worry with >> this in the first place? > > Even without vectorization the worst case performance hit is about > 20%. This is for a workload that

Re: [HACKERS] Questions about checksum feature in 9.3

2013-09-16 Thread Ants Aasma
On Sun, Sep 15, 2013 at 8:13 AM, Kevin wrote: > My attempts to compile it vectorized on OS X seemed to have failed since I > don't find a vector instruction in the .o file even though the options > -msse4.1 -funroll-loops -ftree-vectorize should be supported according to the > man page for Appl

[HACKERS] Questions about checksum feature in 9.3

2013-09-14 Thread Kevin
I am getting a new server ready for production and saw the release note on the new checksum feature. I thought it sounded like something we might want, and then after reading realized we have to initdb with the feature on. I figured I'd better check into it a little more since changing later mig