Re: Gurjeet Singh Index Adviser User Interface

From: Yessica Brinkmann <brinkmann(dot)yessica(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Rob Sargent <robjsargent(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Gurjeet Singh Index Adviser User Interface
Date: 2020-10-10 05:52:25
Message-ID: CAOR+mcfx7=uGqG7S02q-j6zD7xfQ1zxdtbFM9mKprmyu6fC3RQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you very much for the answer.
I will be trying to understand and test the indicated.
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>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

El vie., 9 oct. 2020 a las 23:02, David G. Johnston (<
david(dot)g(dot)johnston(at)gmail(dot)com>) escribió:

> On Fri, Oct 9, 2020 at 5:20 PM Yessica Brinkmann <
> brinkmann(dot)yessica(at)gmail(dot)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.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2020-10-10 08:41:33 Re: Writing WAL files
Previous Message David G. Johnston 2020-10-10 02:02:29 Re: Gurjeet Singh Index Adviser User Interface