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.
>
>
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 |