Kai-Uwe Sattler wrote:
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.

You know we don't put new features on stable branches, right? If you want to submit a new feature it has to be against CVS HEAD (and we are currently in feature freeze there too)



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to