Re: Gurjeet Singh Index Adviser User Interface

I will greatly appreciate a help with this topic please. I really need to use that interface to be able to test my thesis. And I am not being able to use.<br>Best regards,<br>Yessica Brinkmann<div class="quote" style="line-height: 1.5"><br><br>-------- Mensaje original --------<br>Asunto: Gurjeet Singh Index Adviser User Interface<br>De: Yessica Brinkmann <brinkmann(dot)yessica(at)gmail(dot)com><br>Para: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org><br>CC: <br><br><br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">
<div class="gmail-text-wrap gmail-tlid-copy-target"><div class="gmail-result-shield-container gmail-tlid-copy-target" tabindex="0"><span class="gmail-tlid-translation gmail-translation" lang="en">Goodnight,<br>I would like to ask the following question:<br>As some of you may recall, I was doing my university thesis as a modification of Gurjeet Singh&#39;s Index Adviser.<br>Now I have finished the programming part.<br>But I have the following problem:<br>Gurjeet Singh&#39;s Index Adviser readme describes how to use an Index Adviser interface called pg_advise_index tool.<br>The readme mentions the following:<br>i) pg_advise_index tool.<br> ---------------------<br><br> Create a file that contains all the queries (semicolon terminated; may<br>be multi-line) that are expected to be executed by the application; and<br>feed this file to the pg_advise_index tool with appropriate options.<br><br> pg_advise_index -d DB -h host -U user -s 10M -o advisory.sql workload.sql<br><br> pg_advise_index will open a connection with the PostgreSQL server by<br>setting appropriate session level options that will force the backend to load<br>the pg_index_adviser plugin. It will then prepend the keywords EXPLAIN to each<br>of the queries found in the workload file, and execute them against the backend.<br>For each query EXPLAINed, the backend will generate advice for each index that<br>might have been beneficial in executing these queries.<br><br> At the end, pg_advise_index will enumerate all the indexes suggested for<br>the current session, and output the CREATE INDEX statements for each of them.<br>Optinally, if the -size option was specified, pg_advise_index will output suggestions<br>for only those indexes, that fit into that size.<br>-------------------------------------------------- ----------------------------------------<br>To test my thesis, I need to use this interface pg_advise_index tool, but unfortunately I have not been able to use it yet.<br>I would like to know if any of you have any experience testing or using this interface, or if you understand what the readme says anyway.<br>In that case, please, can you help me. Now to test my thesis.<br>I&#39;ve actually already tried to run this interface pg_advise_index tool in various ways but haven&#39;t been able to.<br>What I don&#39;t understand specifically is from which directory should I run the command<br> pg_advise_index -d DB -h host -U user -s 10M -o advisory.sql workload.sql<br>I will greatly appreciate any help, please.</span></div><div class="gmail-result-shield-container gmail-tlid-copy-target" tabindex="0"><span class="gmail-tlid-translation gmail-translation" lang="en"><br></span></div><div class="gmail-result-shield-container gmail-tlid-copy-target" tabindex="0"><span class="gmail-tlid-translation gmail-translation" lang="en">
<span class="gmail-tlid-translation gmail-translation" lang="en">The Index Adviser readme link is as follows:</span>

</span></div><div class="gmail-result-shield-container gmail-tlid-copy-target" tabindex="0"><span class="gmail-tlid-translation gmail-translation" lang="en"><a href="https://github.com/gurjeet/pg_adviser/blob/master/index_adviser/README.index_adviser">https://github.com/gurjeet/pg_adviser/blob/master/index_adviser/README.index_adviser</a></span></div><div class="gmail-result-shield-container gmail-tlid-copy-target" tabindex="0"><span class="gmail-tlid-translation gmail-translation" lang="en">Best regards,</span><span class="gmail-tlid-translation-gender-indicator gmail-translation-gender-indicator"></span></div></div>

<div><br></div><div>Yessica Brinkmann<br></div></div>
</blockquote></div>