Re: Gurjeet Singh Index Adviser User Interface - Mailing list pgsql-general

From Yessica Brinkmann
Subject Re: Gurjeet Singh Index Adviser User Interface
Date
Msg-id CAOR+mcefJpbSbNruP9C6aTNE1JsbxiDMuhLeyhi0VG+BUPhX2Q@mail.gmail.com
Whole thread Raw
In response to Re: Gurjeet Singh Index Adviser User Interface  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Gurjeet Singh Index Adviser User Interface  (Yessica Brinkmann <brinkmann.yessica@gmail.com>)
List pgsql-general
Goodnight,
Thank you very much for the answer.
I followed all the installation instructions: apply patch, compile
install postgres, etc.
I just tried everything with the UI ii) Manually (through psql session), which is also mentioned in the readme, and everything works for me. But to better test my thesis, I would also need to use the other user interface mentioned in the readme and that is precisely i) pg_advise_index tool.
I understand what you are telling me about the directory. I will be testing this way.
Many thanks.
Best regards,
Yessica brinkmann

El mar., 29 sept. 2020 a las 18:21, Rob Sargent (<robjsargent@gmail.com>) escribió:


On 9/29/20 3:46 PM, Yessica Brinkmann wrote:
> 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.
> Best regards,
> Yessica Brinkmann

I didn't see any reported error messages in your post.

And you followed all the installation instructions: apply patch, compile
install postgres, etc?  Not for the faint of heart, to be sure.

As presented

pg_advise_index -d DB -h host -U user -s 10M -o advisory.sql workload.sql

would need to be run in the directory containing advisory.sql and your
PATH would need to include the directory containing the
'pg_advise_index' executable.





Libre de virus. www.avg.com

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Gurjeet Singh Index Adviser User Interface
Next
From: Olivier Leprêtre
Date:
Subject: Postgres going very slow