Re: [PATCHES] index advisor

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Kai-Uwe Sattler <kus(at)tu-ilmenau(dot)de>
Subject: Re: [PATCHES] index advisor
Date: 2006-10-13 19:10:45
Message-ID: 20061013191045.GM28647@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Moving to -hackers...

On Fri, Oct 13, 2006 at 03:07:50PM -0400, Andrew Dunstan wrote:
> 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)

This patch was submitted so people (ie: Simon) could see what had been
done for index recommendations.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message AgentM 2006-10-13 19:10:52 Re: more anti-postgresql FUD
Previous Message Andrew Dunstan 2006-10-13 19:07:50 Re: index advisor

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-10-13 22:05:33 Re: index advisor
Previous Message Andrew Dunstan 2006-10-13 19:07:50 Re: index advisor