https://prefect.io logo
Title
t

Thomas Pedersen

03/09/2023, 6:33 AM
Just to share, Disabling JIT on the PostgreSQL running the Prefect DB, significantly reduces peak load on the database (see screenshot). I ran the Prefect DB with pg_stat_statements to identify where our timeout issues came from. A query starting with
WITH RECURSIVE typeinfo_tree ...
was by far the heaviest. Several places online this was reported to be related to JIT (e.g. https://github.com/MagicStack/asyncpg/issues/530) so I attempted to disable JIT (
-c jit=false
when starting the PostgreSQL docker container) ... and then all the peak loads disappeared from our server. (Prefect 2.7.12)
🔥 2
t

Tim Galvin

03/09/2023, 7:03 AM
That is some nice detective work!