On Tue, 2022-11-29 at 19:09 +0100, Alvaro Herrera wrote:
On 2022-Nov-29, Mladen Gogala wrote:Hmmm, I think I will run pgbench with and without JIT on and see thedifference.I doubt you'll notice anything, because the pgbench queries will be farbelow the JIT cost, so nothing will get JIT compiled at all. Or are youplanning on using a custom set of queries?
Nope. I am planning to set jit_above_cost parameter to 5. That should take care of the pgbench problem. Other than that, you're right: JIT should not be used for OLTP. However, pure OLTP or DW databases are a rarity these days. Reporting is a crucial function and almost every OLTP database that I've seen also has reporting function, which means that there are complex queries to be executed.
--
Mladen Gogala
Database Consultant
