Hi,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. Best, Kai
indexadvisor.patch.gz
Description: GNU Zip compressed data
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings