Re: Pg_repack

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux