Thread: 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.