here is a patch implementing an index recommendation advisor for 7.4.13. It consists of extensions to the planner and the catalog as well as a command line tool pg_advise in contrib. The index advisor works as part of the EXPLAIN statement, i.e. by
set enable_indexadvisor=true;
explain select ...
you will find the recommended indexes in pg_indexadvisor afterwards.

Comments are welcome.

Attachment: indexadvisor.patch.gz
Description: GNU Zip compressed data

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to