Thread: Index Selection Problem

Index Selection Problem

From
"phd9110"
Date:
Hi
 
I and my lab is interesting in the index selection problem.
Is there any index selection tools ( like MS SQL Server index tuning wizard ) in postgresql ?
Is  there  any project about this problem which is going
If we want to develop this tool , what document i should read. or where i can get more support.
 
 If you have suggestions about this question , please e-mail me: phd9110@cs.nchu.edu.tw
 Thanks in advance.
 
Kao Gonfong
National ChungHsing University , Taiwan

Re: Index Selection Problem

From
Josh Berkus
Date:
M. Gonfong (or M. Kao?)

> I and my lab is interesting in the index selection problem.
> Is there any index selection tools ( like MS SQL Server index tuning wizard
> ) in postgresql ? Is  there  any project about this problem which is going
> If we want to develop this tool , what document i should read. or where i
> can get more support.

Check out the developer web site:
http://developer.postgresql.org

There is documentation there to give you an overview of the PostgreSQL 
internals.

Unlike SQL Server, PostgreSQL does not permit "index hints" in queries.  
Postgres' philosophy, to date, has been to improve the query planner as much 
as possible and to focus on whole-database tuning tools rather than giving 
users ways to override the planner on a per-query basis. (Am I getting this 
right, Tom?)

That being said, I know the team could use some help in improving the 
planner's behavior, for example in the selectivity of subselects in the WHERE 
clause.  If you are interested in contributing to the project, join the 
PGSQL-HACKERS mailing list and propose your patch there.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco