Re: JIT overhead slowdown

From: Luis Carril <luis(dot)carril(at)swarm64(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: JIT overhead slowdown
Date: 2019-01-18 18:02:43
Message-ID: LEXPR01MB098999F9AA40877D4A6F87E4E79C0@LEXPR01MB0989.DEUPRD01.PROD.OUTLOOK.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Andres,

yes please it would be much apreciated. Would it not be possible to share the jitted program across the workers?

Cheers,
Luis

Dr. Luis M. Carril Rodríguez
Senior Software Engineer
luis(dot)carril(at)swarm64(dot)com<mailto:lisa(at)swarm64(dot)com>

Swarm64 AS
Parkveien 41 B | 0258 Oslo | Norway
Registered at Brønnøysundregistrene in Norway under Org.-Number 911 662 787
CEO/Geschäftsführer (Daglig Leder): Dr. Karsten Rönner; Chairman/Vorsitzender (Styrets Leder): Dr. Sverre Munck

Swarm64 AS Zweigstelle Hive
Ullsteinstr. 120 | 12109 Berlin | Germany

Registered at Amtsgericht Charlottenburg - HRB 154382 B

[cid:01158560-9a6f-4435-8170-02d99a0c9cd0]
________________________________
From: Andres Freund <andres(at)anarazel(dot)de>
Sent: Friday, January 18, 2019 5:42:54 PM
To: Luis Carril
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: JIT overhead slowdown

Hi,

On 2019-01-18 14:12:23 +0000, Luis Carril wrote:
> Is this behavior expected? Is the cost function for jitting missing some circumstances?

The costing doesn't take the effect of overhead of repeated JITing in
each worker into account. I could give you a test patch that does, if
you want to play around with it?

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Amit Langote 2019-01-19 12:17:34 Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0
Previous Message Andres Freund 2019-01-18 16:42:54 Re: JIT overhead slowdown