[PATCHES] index advisor

[Kai-Uwe Sattler]

Hi,

set enable_indexadvisor=true;
explain select ...
you will find the recommended indexes in pg_indexadvisor afterwards.

Comments are welcome.
Best,
   Kai

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

indexadvisor.patch.gz
Description: GNU Zip compressed data

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