Re: Pg_repack

We are planning to run pg repack from pg_cron in RDS environment not in
EC2 help me schedule job pg_repack

On Tue, Jul 23, 2024, 11:13 AM khan Affan <bawag773(at)gmail(dot)com> wrote:

> Hi
>
> First, use Vaccum Full or Vaccumlo if storing largeobject for clearing
> bloat, If you are running a script, dump it outside the RDS, such as you
> can dump it to EC2, and then apply PG_repack on the schema and then restore
> it to RDS.
>
> As you know such services are not available on RDS.
>
> https://www.postgresql.org/docs/current/vacuumlo.html
>
> https://www.postgresql.org/docs/current/sql-vacuum.html
>
> Thanks & regards
>
>
> *Muhammad Affan (*아판*)*
>
> *PostgreSQL Technical Support Engineer** / Pakistan R&D*
>
> Interlace Plaza 4th floor Twinhub office 32 I8 Markaz, Islamabad, Pakistan
>
> On Tue, Jul 23, 2024 at 10:22 AM Sathish Reddy <
> sathishreddy(dot)postgresql(at)gmail(dot)com> wrote:
>
>> Hi
>> 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 .
>>
>>
>> Thanks
>> Sathish Reddy
>>
>