fix: only keep 1mil pg_cron job run details during pg_upgrade (supabase#1174)

pcnc · web-flow · commit 552a9d322896 · 2024-08-27T08:38:35.000+08:00
diff --git a/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh b/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh
@@ -64,7 +64,7 @@ EOF
         RECREATE_PG_CRON_QUERY=$(cat <<EOF
         begin;
         create temporary table cron_job as select * from cron.job;
-        create temporary table cron_job_run_details as select * from cron.job_run_details;
+        create temporary table cron_job_run_details as select * from cron.job_run_details order by start_time desc limit 1000000;
         drop extension pg_cron;
         create extension pg_cron schema pg_catalog;
         insert into cron.job select * from cron_job;
