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

darora · darora · commit 117c07da808b · 2024-08-27T08:59:42.000+08:00
This reverts commit 552a9d3.
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 order by start_time desc limit 1000000;
+        create temporary table cron_job_run_details as select * from cron.job_run_details;
         drop extension pg_cron;
         create extension pg_cron schema pg_catalog;
         insert into cron.job select * from cron_job;
