Room: Club Parlor
Just-in-time compilation was first released in PostgreSQL 11 as a way to speed up query execution. It has since been further developed and refined, and can make certain types of queries much faster. There are however a lot of misconceptions around JIT in postgres, this talks aims to address these and much more.
The talk start with a primer about what JIT is, how it works, when it's beneficial and when it can be detrimental to query performance. We will then go on and discuss how to tailor queries to make use of JIT. Lastly, we will look at exciting work which is being done to make JIT query execution even faster.