Re: Pg_repack

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.

Yours,
Laurenz Albe