[postgis-devel] Much slower processing on GEOS 3.9.0 versus 3.8.0 for geodesic area calculation - Upgrade to PROJ 7.2.1 causes issue

[Marco Boeringa]

Hi Paul and others,

Ok, so that issue with the wrong display of the PROJ version number when 
calling 'postgis_full_version' after the upgrade of PROJ from 6.3.1 to 
7.2.1 using the UbuntuGIS repository available version, is insignificant.

Is there anything else you want me to do? Even if I had the experience, 
I do not have the infrastructure to debug PostGIS / PROJ or anything 
else involved, except for the PostgreSQL / PostGIS install on Ubuntu. 
You posted a GitHub link to a C file 
(https://gist.github.com/pramsey/493b2490a8736fd8c00e30efa62e4ec3), but 
I am unsure what to do with it. How do I run this?

And what is the status of the speculation about a possible compiler 
optimization setting issue with PROJ 7.2.1 as available from the 
UbuntuGIS apt repository? Is there any new information about this?

Marco

Op 30-4-2021 om 17:16 schreef Paul Ramsey:
>
>
>> On Apr 30, 2021, at 1:05 AM, Marco Boeringa <marco at boeringa.demon.nl 
>> <mailto:marco at boeringa.demon.nl>> wrote:
>>
>> Lastly, I am still a bit worried about the fact that 'SELECT 
>> postgis_full_version()' returns the old '6.3.1' PROJ version number 
>> after upgrading PROJ to '7.2.1'. Is there any logical explanation for 
>> this, e.g. 'postgis_full_version' only ever returning the version 
>> number of the PROJ it was originally compiled against, so never 
>> displaying the upgrade?
>
> Sure, it’s fairly common, all you need is a library where the version 
> information is communicated via compile-time #defines rather than a 
> run-time getversion() function. Or a library that does both (like 
> proj) and the implementing application uses the #defines. Early proj4 
> only had #defines, so it wouldn’t be surprising to find apps that 
> still use them, even though modern proj has a runtime proj_version() 
> available.
>
> P
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20210506/8352dd07/attachment.html>