| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org, keith(dot)fiske(at)crunchydata(dot)com, Keith <keith(at)keithf4(dot)com> |
| Subject: | Re: Pg_repack |
| Date: | 2024-07-23 07:01:36 |
| Message-ID: | 5b2b5a4a0f1c2593bccf1eb9537269780aeac00d.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sathish Reddy | 2024-07-23 07:20:37 | Re: Pg_repack |
| Previous Message | Mahendra Singh | 2024-07-23 06:52:32 | Re: WAL file corruption on standby PostgreSQL |