Hello,
* Add tool to query pg_stat_* tables and report indexes that aren't needed or tables that might need indexes
Good.
This is the kind of things I'm planning for the "pg-advisor" tool, which queries system relations thru views and report inconsistencies (such as mismatching types for foreign references...).
This particular one is not checked, but could be added quite easily.
See http://pgfoundry.org/projects/pg-advisor/ for details and a prototype. I must admit I don't have much time recently so the project is "stuck", although not forgotten.
-- Fabien.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
