Thread: Gurjeet Singh Index Adviser User Interface
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
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.
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 brinkmann
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 brinkmann
El 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.
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.
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.
Thank you very much for the answer.
I will be trying to understand and test the indicated.
Best regards,
Yessica Brinkmann.
I will be trying to understand and test the indicated.
Best regards,
Yessica Brinkmann.
El vie., 9 oct. 2020 a las 23:02, David G. Johnston (<david.g.johnston@gmail.com>) escribió:
On Fri, Oct 9, 2020 at 5:20 PM Yessica Brinkmann <brinkmann.yessica@gmail.com> wrote:I am using Postgresql 8.3.23, I really use this version because the Index Adviser only works with this version of Postgresql.I suggest first figuring out whether you are able to successfully install the current PostgreSQL Server (git master branch) on a current Linux release (if you really want to go Windows feel free but there is less help to be had there.) Until you can get that to work you should not proceed any further on attempting to modify PostgreSQL server.Then, instead of trying to get ancient PostgreSQL server code running on modern hardware, you should focus your attention on getting ancient third-party modifications to the PostgreSQL server code to work on the modern PostgreSQL server.As an aside, I noticed the "USE_PGXS = 1", it didn't exist back in the 8.3 days.As far as I can see, in a limited read of the readme summary, all of the relevant code needs to exist within the PostgreSQL server source tree, the pg_advise_index being placed in the contrib section just like, for example, hstore or pg_prewarm (which I think has a command line interface). Then you modify, build and install the server and the modifications are fully incorporated as core+contrib code. This seems all quite straight-forward, with plenty of examples to copy from, for dealing with the overall structural aspects of the codebase and build/install processes. Which brings me back to first understanding how the unaltered system works before trying to make alterations. You may choose to learn that using an 8.3 server but you will probably find little help if you go that route.David J.David J.
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.