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.
https://github.com/cohenjo/pg_idx_advisor 
<https://github.com/cohenjo/pg_idx_advisor>

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 <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.yess...@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.
> 
> 
>  
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>      Libre de virus. www.avg.com 
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>  <x-msg://4/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> El jue., 8 oct. 2020 a las 22:21, Yessica Brinkmann 
> (<brinkmann.yess...@gmail.com <mailto:brinkmann.yess...@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.
> 
>  
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>      Libre de virus. www.avg.com 
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>  <x-msg://4/#m_-9019273329787422367_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> El jue., 8 oct. 2020 a las 22:08, Yessica Brinkmann 
> (<brinkmann.yess...@gmail.com <mailto:brinkmann.yess...@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 brinkmann
> 
>  
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>      Libre de virus. www.avg.com 
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>  
> <x-msg://4/#m_-9019273329787422367_m_-2818491497838977803_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> El mar., 29 sept. 2020 a las 18:55, Yessica Brinkmann 
> (<brinkmann.yess...@gmail.com <mailto:brinkmann.yess...@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 brinkmann
> 
> El mar., 29 sept. 2020 a las 18:21, Rob Sargent (<robjsarg...@gmail.com 
> <mailto:robjsarg...@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.
> 
> 
> 
> 
> 
>  
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>      Libre de virus. www.avg.com 
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>  
> <x-msg://4/#m_-9019273329787422367_m_-2818491497838977803_m_-6212125912420465024_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Reply via email to