Postgres Pro
Downloads
Home   >   mailing lists

Re: Unused indexes - Mailing list pgsql-general

From Ron Johnson
Subject Re: Unused indexes
Date
Msg-id CANzqJaCnoZH3O-dNxKq1wZEPTpSOS2H3+LC9KdqbZnizNnwrXg@mail.gmail.com
Whole thread Raw
In response to Unused indexes  (arun chirappurath <arunsnmimt@gmail.com>)
Responses Re: Unused indexes  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-general
Tree view
On Mon, Feb 5, 2024 at 9:02 AM arun chirappurath <arunsnmimt@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;. 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY
Next
From: Devrim Gündüz
Date:
Subject: Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common