Re: JIT overhead slowdown - Mailing list pgsql-performance

From Luis Carril
Subject Re: JIT overhead slowdown
Date
Msg-id LEXPR01MB098999F9AA40877D4A6F87E4E79C0@LEXPR01MB0989.DEUPRD01.PROD.OUTLOOK.DE
Whole thread Raw
In response to Re: JIT overhead slowdown  (Andres Freund <andres@anarazel.de>)
Responses Re: JIT overhead slowdown  (Justin Pryzby <pryzby@telsasoft.com>)
List 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.carril@swarm64.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 




From: Andres Freund <andres@anarazel.de>
Sent: Friday, January 18, 2019 5:42:54 PM
To: Luis Carril
Cc: pgsql-performance@lists.postgresql.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
Attachment

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: JIT overhead slowdown
Next
From: Fabio Pardi
Date:
Subject: Re: Memory and hard ware calculation :