pgsql: Add: > * Add tool to query pg_stat_* tables and report indexes
Log Message:
-----------
Add:
* Add tool to query pg_stat_* tables and report indexes that aren't needed
or tables that might need indexes
Modified Files:
--------------
pgsql/doc:
TODO (r1.1499 -> r1.1500)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1499&r2=1.1500)
pgsql/doc/src/FAQ:
TODO.html (r1.6 -> r1.7)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.6&r2=1.7)
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.