Postgres Pro
Downloads
Home   >   mailing lists

Re: Pg_repack - Mailing list pgsql-admin

From Kashif Zeeshan
Subject Re: Pg_repack
Date
Msg-id CAAPsdheVt0wXNgNGTsP29udcbYe=htht5ZChgnW0ZxtHZzNKOA@mail.gmail.com
Whole thread Raw
In response to Pg_repack  (Sathish Reddy <sathishreddy.postgresql@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com> 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 

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Pg_repack
Next
From: Sathish Reddy
Date:
Subject: Re: Pg_repack