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
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
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.postgresql@xxxxxxxxx> wrote:
HiI 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 .ThanksSathish Reddy
