Collected from the PG bugs email list.
|Reported by||Александр Филиппенко|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 16136 Logged by: Александр Филиппенко Email address: (redacted) 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)
|2019-11-25 13:00:34+00||PG Bug reporting form||BUG #16136: Bug with cost calculation and JIT application|
|2019-11-25 13:27:15+00||Tomas Vondra||Re: BUG #16136: Bug with cost calculation and JIT application|