Hi,
On Fri, Jan 18, 2019 at 02:12:23PM +, Luis Carril wrote:
> we noticed that in the presence of a schema with many partitions the
> jitting overhead penalizes the total query execution time so much that the
> planner should have decided not to jit at all. For example without jitting
enburg - HRB 154382 B
[cid:01158560-9a6f-4435-8170-02d99a0c9cd0]
From: Andres Freund
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 +, Luis
Hi,
On 2019-01-18 14:12:23 +, 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