On Mon, Feb 5, 2024 at 9:02 AM arun chirappurath <arunsnm...@gmail.com> wrote:
> Hi All, > > Do we have a script to get unused indexes for 30 days and once identified > do we have an option to disable and enable when required? > The pg_stat_*_tables tables idx_* columns has accumulated usage since the last time you started the postmaster. > I sql server we have this option to disable it and need to rebuild it to > ensemble it > Sadly, PG does not have ALTER INDEX ... DISABLE;.
