[postgis-users] st_transform performance after upgrade

[Bo Guo]

Hi there,

One of our Postgresql Servers was recently upgraded

from

POSTGIS="3.2.1 5fae8e5" [EXTENSION] PGSQL="130" (procs need upgrade for use
with PostgreSQL "140") GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 4.9.3,
15 August 2016" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.2.1"
WAGYU="0.5.0 (Internal)" TOPOLOGY
on
PostgreSQL 14.8 (Ubuntu 14.8-1.pgdg18.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit

to

POSTGIS="3.3.4 3.3.4" [EXTENSION] PGSQL="140" GEOS="3.8.0-CAPI-1.13.1 "
PROJ="6.3.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3"
WAGYU="0.5.0 (Internal)" TOPOLOGY
on
PostgreSQL 14.9 (Ubuntu 14.9-1.pgdg20.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit

But we ran into severe (15 times) performance degradation when making CS
transformation calls such as st_transform (geom, proj4, 4326)

Could someone help me with this?

Cheers,


*Bo*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230823/073eac02/attachment.htm>