Postgres 12+ needs to have JIT disabled

[Blake GH]

Newer versions of PostgreSQL (12 and up) include a new feature called JIT (Just-in-Time compilation). https://www.postgresql.org/docs/current/jit-reason.html

This feature can slow Evergreen significantly. This is where we encountered it first but there are almost certainly other queries:

explain (analyze,buffers) select * from reporter.old_super_simple_record where id=xxxx

Changes to the install instructions incoming

[Blake GH (bmagic)]

For your consideration

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/blake/lp2042158_pg12_and_above_disable_jit

[Jeff Davis (jdavis-sitka)]

I've also run into this issue on Postgres 14, and the recommendation in Blake's branch (setting jit_above_cost = -1 in postgresql.conf) resolved the problem for me.