Thread: Index Selection Tool For PostgreSQL

Hello,

I am a master's student in CSE department at IIT Bombay. As an academic course project, I have developed a tool for index selection in PostgreSQL. The tool takes a workload file as in input and outputs a set of create index statements. The workload file consists queries along with their frequency of execution in the workload.

I wish to contribute my code to PostgreSQL. I am not sure if such a tool already exists for PostgreSQL.The details of the tool are in the attached specification.

Presently, I have injected my code in postgres.c in the tcop in an ad-hoc way.  I am yet to put the code at the right places.

Please could you have a look at the design specification and let me know your suggestions?


Thanks,
Mahendra Chavan
CSE, MTech,
IIT Bombay

Mahendra,

> I wish to contribute my code to PostgreSQL. I am not sure if such a tool
> already exists for PostgreSQL.The details of the tool are in the
> attached specification.

This really should be a separate tool from the Postgres executable
itself, since users would want it only at design time and not at
runtime.  So putting the code in postgres.c at all is not the right way
to go.  It needs to be a loadable module.

If you want to put the code you have up somewhere, I'd happily give you
control of this project:
http://pgfoundry.org/projects/index-adviser/

... which has been dead for 2 years, and never produced any working code.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com