PGCon2018 - 2.5

PGCon 2018
The PostgreSQL Conference

Andres Freund
Day Talks - Day 2: Friday - 2018-06-01
Room DMS 1160
Start time 14:00
Duration 00:45
ID 1220
Event type Lecture
Track Performance
Language used for presentation English

The State of Postgres JIT - 2018 Edition

Just in time (JIT) compilation for postgres tries to accelerate query processing by transforming parts of query into native programs. Over the last year a lot of progress towards an in-core implementation of that has been made.

This talk will discuss how much JITing infrastructure has been integrated into postgres already, how those parts work, and show a few benchmark numbers.

The rest of the talk will discuss what needs to be improved with the integrated JIT (e.g. caching of programs, improving program generation) and what further parts of query execution could be JITed (e.g. various server-side languages, the main volcano executor, ...).