Data

reminder that turning jit=off can sometimes be incredibly helpful for query speed. i have a 400 line query that dropped from ~0.7s to ~0.02s as a result. that's a ~40x speedup, and i have to run the query ~5m times.

eli5 jit: jit is like quickly translating just the tricky parts of a recipe into your native language right before you cook, to make cooking faster overall. but this translation takes time, and it's not always worthwhile.

even though my query is long and complex (lots of ctes, recursion, joins, functions), turning jit off made it faster. benchmarking is worthwhile!