Re: effect of JIT tuple deform?

2018-07-02 Thread Pierre Ducroquet
On Wednesday, June 27, 2018 5:38:31 PM CEST Pavel Stehule wrote: > 2018-06-27 17:19 GMT+02:00 Tomas Vondra : > > On 06/26/2018 09:25 PM, Pavel Stehule wrote: > >> Hi > >> > >> ... > >> > >> So I am able to see effect of jit_tuple_deforming, and very well, but > >> only if optimization is active.

Re: effect of JIT tuple deform?

2018-06-27 Thread Pavel Stehule
2018-06-27 17:19 GMT+02:00 Tomas Vondra : > On 06/26/2018 09:25 PM, Pavel Stehule wrote: > >> Hi >> >> ... >> >> So I am able to see effect of jit_tuple_deforming, and very well, but >> only if optimization is active. When optimization is not active then >> jit_tuple_deforming does slowdown. >>

Re: effect of JIT tuple deform?

2018-06-27 Thread Tomas Vondra
On 06/26/2018 09:25 PM, Pavel Stehule wrote: Hi ... So I am able to see effect of jit_tuple_deforming, and very well, but only if optimization is active. When optimization is not active then jit_tuple_deforming does slowdown. So maybe a usage of jit_tuple_deforming can be conditioned by

Re: effect of JIT tuple deform?

2018-06-26 Thread Pavel Stehule
Hi I played with it and maybe I got interesting result. When I played with really big table, then I got IO waits and effect of jit_tuple_deforming is near to zero (as expected) When I played with smaller table under RAM, then I can see positive effect of JIT_TD, but only when optimization is

Re: effect of JIT tuple deform?

2018-06-24 Thread Pavel Stehule
t; > > > > > > 2018-06-23 8:35 GMT+02:00 Pavel Stehule : > > > >> > > > >> Hi > > > >> > > > >> I try to measure effect of JIT tuple deform and I don't see any > possible > > > >> effect. > > > >&g

Re: effect of JIT tuple deform?

2018-06-24 Thread Andres Freund
On 2018-06-25 05:32:37 +0200, Pavel Stehule wrote: > 2018-06-24 22:32 GMT+02:00 Dmitry Dolgov <9erthali...@gmail.com>: > > > > On 23 June 2018 at 08:47, Pavel Stehule wrote: > > > > > > > > > 2018-06-23 8:35 GMT+02:00 Pavel Stehule : > > >

Re: effect of JIT tuple deform?

2018-06-24 Thread Andres Freund
Hi, On 2018-06-24 22:32:07 +0200, Dmitry Dolgov wrote: > `perf diff` indeed shows that in the first case (with the 4M rows dataset) the > jitted version has some noticeable delta for one call, and unfortunately so > far > I couldn't figure out which one exactly because of JIT (btw, who can

Re: effect of JIT tuple deform?

2018-06-23 Thread Pavel Stehule
2018-06-23 8:35 GMT+02:00 Pavel Stehule : > Hi > > I try to measure effect of JIT tuple deform and I don't see any possible > effect. > > Is it this feature active in master branch? > > Is possible to see this feature in EXPLAIN ANALYZE? > Unfortunately I got slowdown

effect of JIT tuple deform?

2018-06-23 Thread Pavel Stehule
Hi I try to measure effect of JIT tuple deform and I don't see any possible effect. Is it this feature active in master branch? Is possible to see this feature in EXPLAIN ANALYZE? Regards Pavel