Re: [HACKERS] Quantify small changes to predicate evaluation

2014-06-25 Thread Marti Raudsepp
On Tue, Jun 17, 2014 at 5:23 PM, Dennis Butterstein wrote: > I tried the proposed tweaks and > see some differences regarding the measurements. > Unfortunately the variance between the runs seems to remain high. Using these techniques I managed to get standard deviation below 1.5% in my read-only

Re: [HACKERS] Quantify small changes to predicate evaluation

2014-06-18 Thread Robert Haas
On Tue, Jun 17, 2014 at 10:23 AM, Dennis Butterstein wrote: > Hi Marti, thank you for your quick reply. I tried the proposed tweaks and > see some differences regarding the measurements. It seems as if the overall > query performance dropped a little what I think the disabled turbo boost > mode is

Re: [HACKERS] Quantify small changes to predicate evaluation

2014-06-17 Thread Dennis Butterstein
Hi Marti,thank you for your quick reply.I tried the proposed tweaks and see some differences regarding the measurements. It seems as if the overall query performance dropped a little what I think the disabled turbo boost mode is responsible for (all measurements are single query only). I think tha

Re: [HACKERS] Quantify small changes to predicate evaluation

2014-06-13 Thread Marti Raudsepp
On Fri, Jun 13, 2014 at 12:46 PM, Dennis Butterstein wrote: > I expect my current changes to be resposible for about 0.2-0.3s for this > query but because of the huge time differences I am not able to quantify my > changes. > > Maybe somebody can tell me about a better approach to quantify my chan

[HACKERS] Quantify small changes to predicate evaluation

2014-06-13 Thread Dennis Butterstein
Hello everybody, I am currently trying to squeeze some performance out of the current predicate evaluation implementation. In fact I was able to get some positive results. I have some more points on my developement plan, but I am facing the problem that theses changes will only help very little wh