django-planet
Nov. 9, 2023

Django: Maybe disable PostgreSQL’s JIT to speed up many-joined queries

published by Adam Johnson
in blog Adam Johnson
original entry Django: Maybe disable PostgreSQL’s JIT to speed up many-joined queries

Here’s a write-up of an optimization I made in my client Silvr’s project. I ended up disabling a PostgreSQL feature called the JIT (Just-In-Time) compiler which was taking a long time for little benefit.

This behaviour was observed on PostgreSQL 14, so things may have improved since. Although …