Re: Pg_repack

[Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>]

Hi Sathish

It's better to script it using any scripting language e.g. SHELL Scripting as PL/pgSQL etc don't allow accessing Utilities from stored procedures.

Thanks

Kashif Zeeshan

On Tue, Aug 6, 2024 at 4:10 PM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> wrote:

Hi 

  We planning to create store procedure (function) in postgres database to run pg_repack on removing bloating of table or index by using within postgres instance.

  

    Please help me on details on steps with example for same.

Thanks 

Sathishreddy