From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Sathish Reddy <sathishreddy.postgresql@gmail.com>
To: pgsql-admin@lists.postgresql.org, keith.fiske@crunchydata.com, Keith <keith@keithf4.com>
Subject: Re: Pg_repack
Date: Tue, 23 Jul 2024 09:01:36 +0200
Message-ID: <5b2b5a4a0f1c2593bccf1eb9537269780aeac00d.camel@cybertec.at> (raw)
In-Reply-To: <CA+M9Y+AeXGF8aDPE1_+9j9BQ6=F-XkA-C9MfxNyGmmfOjvrESw@mail.gmail.com>
References: <CA+M9Y+AeXGF8aDPE1_+9j9BQ6=F-XkA-C9MfxNyGmmfOjvrESw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, sathishreddy.postgresql@gmail.com, keith@keithf4.com
Subject: Re: Pg_repack
In-Reply-To: <5b2b5a4a0f1c2593bccf1eb9537269780aeac00d.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox