supabase-postgres.git / summary / log / commit / refs

commit    552a9d3228965be9500cc451f0bb934bf7483f49
Author:   Paul Cioanca <paul.cioanca@supabase.io>
Commit:   GitHub <noreply@github.com>
Date:     Tue Aug 27 00:38:35 2024 +0000

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


 ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh b/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh
index 2c499b48..37c05cb6 100755
--- 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;


[parent: 24e1af513154]