On Tue, 2024-07-23 at 10:52 +0530, Sathish Reddy wrote: > I am trying to schedule pg_repack from pg_cron in RDS postgres environment on avoid > the bash on host EC2 to run run directly with in postgres instance.it getting successful > but not clearing bloat by using repack fuction in pg_repack extension.please help on > these to sort out .
If you have the need to do this regularly, use pg_squeeze, which avoids the need for pg_cron. It can automatically trigger a rebuild of the table according to conditions you specify.
