Skip to content

Improving Postgresql-9.1.4 to support semi-automatic index tuning

Notifications You must be signed in to change notification settings

elacour/postgresql-tuning

 
 

Repository files navigation

This project aims to add semi-automatic index tuning to postgresql (9.1.4 version)
as described in http://arxiv.org/pdf/1004.1249v6.pdf

We need hypothetical indexes for the process and are using code base from http://www.inf.puc-rio.br/~postgresql/index.php?lan=en as base.

References:
* Semi-Automatic Index Tuning: Keeping DBAs in the Loop http://arxiv.org/pdf/1004.1249v6.pdf

------------------------------------------------------------------------------------------

1. Setup postgresql(patched) (Location: postgresql-9.1.4) according to instructions in http://www.cse.iitb.ac.in/dbms/Data/Courses/CS631/PostgreSQL-Resources/pgsql_demo.txt
2. Create user postgres with password postgres and assign superuser role
3. Import dellstore2-normal-1.0.sql into a database named dellstore2
Note: Other database dumps can also be used. Corresponding changes are needed to be made in 'PostgreSQL_index_tuning/src/in/ac/iitb/cse/dbms/pg_indextuning/AdminDB.java'
4. Import the project present in PostgreSQL_index_tuning into eclipse.
Add external_jars as External project jars
5. Run the main function in AdminDB.java

More details about file structure is in report
-----------------------------------------------------------------------------------------

About

Improving Postgresql-9.1.4 to support semi-automatic index tuning

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C 69.7%
  • PLpgSQL 23.3%
  • C++ 2.1%
  • Yacc 1.3%
  • Makefile 0.8%
  • SQLPL 0.7%
  • Other 2.1%