Hi, In the TODO there's an item for the server to suggest indexes:
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 oliver@xxxxxxxxxx / 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). |
