Re: Postgresql 14 performance

Hi again,

JIT is already enabled. And here is the perf top output:

Kenny, JIT is not mentioned in any of your plans. Look how it looks, with JIT enabled:

                                              QUERY PLAN                                               
-------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1682569.70..1682569.71 rows=1 width=8)
   ->  Nested Loop  (cost=0.00..1419035.94 rows=105413504 width=0)
         ->  Nested Loop  (cost=0.00..101365.96 rows=7529536 width=0)
               ->  Nested Loop  (cost=0.00..7245.59 rows=537824 width=0)
                     ->  Nested Loop  (cost=0.00..521.62 rows=38416 width=0)
                           ->  Nested Loop  (cost=0.00..40.24 rows=2744 width=0)
                                 ->  Nested Loop  (cost=0.00..4.77 rows=196 width=0)
                                       ->  Seq Scan on emp e1  (cost=0.00..1.14 rows=14 width=0)
                                       ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
                                             ->  Seq Scan on emp e2  (cost=0.00..1.14 rows=14 width=0)
                                 ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
                                       ->  Seq Scan on emp e3  (cost=0.00..1.14 rows=14 width=0)
                           ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
                                 ->  Seq Scan on emp e4  (cost=0.00..1.14 rows=14 width=0)
                     ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
                           ->  Seq Scan on emp e5  (cost=0.00..1.14 rows=14 width=0)
               ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
                     ->  Seq Scan on emp e6  (cost=0.00..1.14 rows=14 width=0)
         ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
               ->  Seq Scan on emp e7  (cost=0.00..1.14 rows=14 width=0)
 JIT:
   Functions: 14
   Options: Inlining true, Optimization true, Expressions true, Deforming true
(23 rows)

Look at the end. There is no such section in any of your plans.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com