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.

[Mike Rylander (mrylander)]

Considered, and picked. Thanks, Blake!

[Andrea Neiman (aneiman)]

Does this need to get picked to 3.13 as well?

[Jason Stephenson (jstephenson)]

Yes, but I suspect we're waiting on the 3.13-beta to be officially announced and the next milestone created.

[Mike Rylander (mrylander)]

I've picked this into origin/rel_3_13. Thanks for the reminder to do so, I didn't realize the branch was already there!