Re: Gurjeet Singh Index Adviser User Interface - Mailing list pgsql-general
From | Jony Cohen |
---|---|
Subject | Re: Gurjeet Singh Index Adviser User Interface |
Date | |
Msg-id | 3AA190B6-519C-451E-B292-F7960FE58A56@gmail.com Whole thread Raw |
In response to | Re: Gurjeet Singh Index Adviser User Interface (Yessica Brinkmann <brinkmann.yessica@gmail.com>) |
List | pgsql-general |
Hi Yessica,
Postgres 8.3 is very old, If you are using that simply because of the index advisor there are a few more “modern” options.
I at the time wrote such a tool for Postgres 9.4 (it has many features that the one by Gurjeet didn’t have like CTE and partial indexes support)
Alas I didn’t have a chance to update it to 9.6 & 10 as there were many breaking changes.
And there is even a newer module to generate hypothetical indexes to allow you to test various options before building the actual index: https://github.com/HypoPG/hypopg
You are missing so much functionality and features that any improvements you get by a better index recommendation will still be slower then running a new version with less optimal indexes.
I would consider using a new version.
Kind Regards,
Jony
On 10 Oct 2020, at 3:19, Yessica Brinkmann <brinkmann.yessica@gmail.com> wrote:I will greatly appreciate a help please with this topic. I really need a lot to be able to use this interface to be able to test my thesis well. I really don't quite understand what installing postgresql-server-dev-X.Y refers to. And I really don't really know how to install it too. If you can give me a guide at least about this please? And in which version should I install it? I am using Postgresql 8.3.23, I really use this version because the Index Adviser only works with this version of Postgresql. And also I do not understand well if installing that already solves everything or should I install an additional package?Best regards,Yessica Brinkmann.El jue., 8 oct. 2020 a las 22:21, Yessica Brinkmann (<brinkmann.yessica@gmail.com>) escribió:I also clarify that I tried to install the libpq-dev package already but could not install it because it depends on a non-installable package called libss10.9.8. And I had to apply apt --fix-broken install to fix the problem.El jue., 8 oct. 2020 a las 22:08, Yessica Brinkmann (<brinkmann.yessica@gmail.com>) escribió:Goodnight,
I apologize please that today I was able to test the directory, since I had a health problem in recent days.
Well, I actually found the files corresponding to the pg_advise_index interface. But I was surprised that the executable is not present, but apparently this interface must be compiled by another part of the index adviser, to be able to execute it. It has a Makefile.
I tried to compile as follows, and I get the following errors:
root@debian:/home/yessica/Descargas/postgresql-8.3.23/contrib/pg_adviser_master/pg_advise# USE_PGXS = 1 make
You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
make: *** There are no targets. High.
root@debian:/home/yessica/Descargas/postgresql-8.3.23/contrib/pg_adviser_master/pg_advise# make install
make: Nothing is done for 'install'.
I will greatly appreciate a help please, regarding these errors that I got. The truth is that I honestly don't have much experience using Linux.
Best regards,
Yessica brinkmannEl mar., 29 sept. 2020 a las 18:55, Yessica Brinkmann (<brinkmann.yessica@gmail.com>) escribió: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 brinkmannEl 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.
pgsql-general by date: