Hi,
In the TODO
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
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).