Search Postgresql Archives

Re: Unused indexes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Feb 5, 2024 at 9:02 AM arun chirappurath <arunsnmimt@xxxxxxxxx> 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;


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux