[postgis-users] st_transform performance after upgrade

[Bo Guo]

Mike, Thanks for your post.  Indeed by assigning srid to the geom, we were
back in business!

*Bo*



On Wed, Aug 23, 2023 at 6:25 PM Mike Taves <mwtoews at gmail.com> wrote:

> On Thu, 24 Aug 2023 at 13:08, Bo Guo <bo.guo at gisticinc.com> wrote:
> > But we ran into severe (15 times) performance degradation when making CS
> transformation calls such as st_transform (geom, proj4, 4326)
>
> Note the docs say the geometry ST_Transform(geometry geom, text
> from_proj, text to_proj) is not optimized.
>
> Are you able to assign SRIDs to the geometries and use
> ST_Transform(geometry g1, integer srid)? Are there specific SRIDs that
> are slower?
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230823/c30f243d/attachment.htm>