PGCon2018 - 2.5
PGCon 2018
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Andres Freund |
| Schedule | |
|---|---|
| Day | Talks - Day 2: Friday - 2018-06-01 |
| Room | DMS 1160 |
| Start time | 14:00 |
| Duration | 00:45 |
| Info | |
| 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, ...).