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