Re: pgsql: Add: > * Add tool to query pg_stat_* tables

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: pgsql: Add: > * Add tool to query pg_stat_* tables
Дата
Msg-id Pine.LNX.4.62.0504200806530.21159@sablons.cri.ensmp.fr
обсуждение исходный текст
Ответ на pgsql: Add: > * Add tool to query pg_stat_* tables and report indexes  (momjian@svr1.postgresql.org (Bruce Momjian))
Список pgsql-committers
Дерево обсуждения 
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.

В списке pgsql-committers по дате отправления:

Предыдущее
От: momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Add: > * Add tool to query pg_stat_* tables and report indexes
Следующее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Minor performance improvement: avoid unnecessary