Index Selection Tool For PostgreSQL
Started by mahendra chavanover 16 years ago2 messages
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
Attachments:
IndexSelection.pdfapplication/pdf; name=IndexSelection.pdfDownload
%PDF-1.4
%��������
2 0 obj
<</Length 3 0 R/Filter/FlateDecode>>
stream
x��Z���F��W�z�z�o
������
�0��=0����;��|I�s/.]U�2#N���Z^����?.�e����^�e��u�������������?���������^���?�>�E���o?�����������������?��]���&�}���������z�W�n2p��n��p�����5�=����A����]�b���j���� ��9��b��_>��r�|���M���_�)�k�M�m� ����f��;�i�x>�
09^�v��]��>_3��KX�Lk���^��v�hl���we�;�"~4�Y���qf���\����9X��V��.B�����+_\=�9��������� q�Ww���i��hQ�(���;F �/����g����O^�{�y��/&�i.�0�*���-��_-Do4I����'m �0U�F�z�[ ��G[q�B��>����1.�����E��A@0>�j�t%?8w�%�b{�v�1IV�6<����PZ��0�2�J��
�s14�+��F��6�{��VEG��R4�Bul�S9h�C���1����}�����'���S�t ��!C�?�7��m}^������ D.�1#^�l��|Q����;�#G�#e�Td�x�%@x�T���P����q�9��%��%%i��U��sVay�
�������� A�;����`�1����&��[a��(����=�b
|���_��
W�� ���M�7�q0����c"YSS��S�G�R���D����`V� �f{Q��%m3�j���%�&�S�Yq!��}���Qk� 1���{���62w<��fW"X���q��C�$bv'� +�5m��`�U@��?@}�)2�_,TUR(�����M����x��V�H\���� [��A��;�,P���\�$��G�5�2"&