Re: Unused indexes

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Unused indexes
Дата
Msg-id CANzqJaCnoZH3O-dNxKq1wZEPTpSOS2H3+LC9KdqbZnizNnwrXg@mail.gmail.com
обсуждение исходный текст
Ответ на Unused indexes  (arun chirappurath <arunsnmimt@gmail.com>)
Ответы Re: Unused indexes
Список pgsql-general
Дерево обсуждения
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 по дате отправления: