BUG #16136: Bug with cost calculation and JIT application

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: alexfilus(at)gmail(dot)com
Subject: BUG #16136: Bug with cost calculation and JIT application
Date: 2019-11-25 13:00:34
Message-ID: 16136-34535de58a0ff493@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16136
Logged by: Александр Филиппенко
Email address: alexfilus(at)gmail(dot)com
PostgreSQL version: 12.1
Operating system: Ubuntu 18.04
Description:

I had very strange behaviour of optimizator.
https://explain.depesz.com/s/GcHL
https://explain.depesz.com/s/sTyG
Both explains are for same query and same data set, but in second case I
turn off JIT. I guess it's because of wrong cost calculation like this
Nested Loop (cost=463.86..5575122.76 rows=652 width=74) (actual
time=9.685..67.713 rows=18 loops=1)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2019-11-25 13:27:15 Re: BUG #16136: Bug with cost calculation and JIT application
Previous Message PG Bug reporting form 2019-11-25 10:15:35 BUG #16135: `pgadmin4-web` package fails to update due to missing `pgadmin4-python3-flask-compress`