Skip site navigation (1) Skip section navigation (2)

Re: index advisor

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Kai-Uwe Sattler <kus(at)tu-ilmenau(dot)de>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: index advisor
Date: 2006-10-13 19:07:50
Message-ID: 452FE406.9020009@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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

In response to

Responses

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2006-10-13 19:10:45
Subject: Re: [PATCHES] index advisor
Previous:From: Jim C. NasbyDate: 2006-10-13 18:55:42
Subject: Re: ./configure argument checking

pgsql-patches by date

Next:From: Jim C. NasbyDate: 2006-10-13 19:10:45
Subject: Re: [PATCHES] index advisor
Previous:From: Kai-Uwe SattlerDate: 2006-10-13 18:49:05
Subject: index advisor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group