Suggest Index

Hi,

In the TODO
http://www.postgresql.org/docs/faqs.TODO.html
there's an item for the server to suggest indexes:

SHOW/SET
Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
ANALYZE, and CLUSTER

I haven't seen this mentioned on the list recently but I'd just like
to add a vote for it, at least the INDEX portion.

The reason is that I run an application which is a 'layer of
abstraction' above postgres. It provides a web GUI for creating tables
and fields, reporting etc. At the moment, it manages the creation and
deletion of indexes itself based on various factors, rather than
allowing explicit control. Any slow queries are logged so I can
EXPLAIN ANALYZE them and add indexes manually if necessary.

As of now, no queries have been slow enough to need this. However, it
would be nice to have postgres suggest indexes where necessary. This
would mean that I could be sure that all queries could be optimised
whether they break the 'slow' barrier or not.

Regards
Oliver Kohll
GT webMarque
www.gtportalbase.com

oliver(at)gtwm(dot)co(dot)uk / 0845 456 1810 / 07814 828608
The Old Bank, 4 Ravenhill Rd, Swansea SA5 5AW, UK

NOTE
No contracts may be concluded on behalf of GT webMarque by means of e-
mail
communications. The contents of this e-mail are confidential to the
intended recipient at the e-mail address to which it has been addressed;
it may not be disclosed to or used by anyone other than this addressee,
nor may it be copied in any way. If received in error please return to
sender via e-mail.

DISCLAIMER
Please note that neither GT webMarque Ltd nor the sender accept any
responsibility for viruses transmitted via e-mail. It is your
responsibility to scan attachments (if any).