newer postgresql also jit's some queries in its new query optimizer. but for such use-cases (exact matches, no range queries) it's still better to compile a pe

newer postgresql also jit's some queries in its new query optimizer. but for such use-cases (exact matches, no range queries) it's still better to compile a perfect hash at run-time into a .so/.dll and load this at run-time. way faster.