Hunting Unused Indexes .. is it this simple ?

Поиск
Список
Период
Сортировка
Искать
От
Stef Telford
Тема
Hunting Unused Indexes .. is it this simple ?
Дата
Msg-id
4AB8D9AA.6050007@ummon.com
Список
Дерево обсуждения
Hunting Unused Indexes .. is it this simple ? Stef Telford <stef@ummon.com>
Re: Hunting Unused Indexes .. is it this simple ? Andy Colson <andy@squeakycode.net>
Re: Hunting Unused Indexes .. is it this simple ? Josh Berkus <josh@agliodbs.com>
Autovacuum Tuning advice "Plugge, Joe R." <JRPlugge@west.com>
Re: Autovacuum Tuning advice Greg Williamson <gwilliamson39@yahoo.com>
Re: Autovacuum Tuning advice Scott Marlowe <scott.marlowe@gmail.com>
Re: Autovacuum Tuning advice "Plugge, Joe R." <JRPlugge@west.com>
Re: Autovacuum Tuning advice Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Autovacuum Tuning advice "Plugge, Joe R." <JRPlugge@west.com>
Re: Hunting Unused Indexes .. is it this simple ? Gurjeet Singh <singh.gurjeet@gmail.com>
Hey Everyone,
    So, I have a nice postgreSQL server (8.4) up and running our 
database. I even managed to get master->slave going without trouble 
using the excellent skytools.. however, I want to maximize speed and the 
hot updates where possible, so, I am wanting to prune unused indexes 
from the database.

    is it as simple as taking the output from ; select indexrelname from 
pg_stat_user_indexes where idx_scan = 0 and idx_tup_read = 0 and 
idx_tup_fetch = 0 ;

    And  .. dropping ?


    The reason I ask is, well, the count on that gives me 750 indexes 
where-as the count on all user_indexes is 1100. About 2/3rds of them are 
obsolete ? I did do an ETL from mySQL -> postgreSQL but.. that's still a 
ridiculous amount of (potentially) unused indexes.

    Regards
    Stef
В списке pgsql-performance по дате отправления
От: Shiva Raman
Дата:
От: Merlin Moncure
Дата:
FAQ