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

Automatic index advisor?

From: Bill Karwin <bill(at)karwin(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Automatic index advisor?
Date: 2010-02-27 00:02:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

I'm writing a book on SQL, with a short section about query tuning and  
automatic optimization advisors for different RDBMS platforms, for  
instance, extensions to EXPLAIN that recommend new indexes based on  
workload and query plans.

When I searched for a solution for PostgreSQL, Gurjeet Singh's name  
came up as the designer of an index adviser patch for PG.  But the  
latest information I found was in 2007.

There's also a project at pgFoundry, but it's listed as in a planning  
stage, and there are no releases.

Can I ask what's the status of this capability for PostgreSQL?  Has it  
become part of PostgreSQL 8.x or 9.0?  I couldn't find any information  
in the docs.  Is there any value-add tool for EnterpriseDB?

If Gurjeet's patch is still under development, are there any other  
tools currently available for PostgreSQL that provide this kind of  

Bill Karwin


pgsql-general by date

Next:From: Greg SmithDate: 2010-02-27 08:22:45
Subject: Re: Cacti + PostgreSQL Graphing
Previous:From: Hiroshi InoueDate: 2010-02-26 23:06:31
Subject: Re: trouble with to_char('L')

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