News for hackers. Stuff that matters.
Re:JIT-Compiling SQL Queries in PostgreSQL Using LLVM by baq on Monday February 22, 2021 @12:11PM (#26227018)
i had exactly your scenario in tests: very complex query got jitted with full optimizations (expensive!) and then due to the data, etc. 95% of that query wasn't executed at all. performance tanked.

you have to carefully analyze your queries if you want the jit to be a net benefit - and by carefully, i mean look at explain analyze outputs to check for major mismatches of estimated vs actual rows (say 10x).

There are no comments on this comment yet.