[postgis-users] st_transform performance after upgrade

Mike Taves mwtoews at gmail.com
Wed Aug 23 18:25:10 PDT 2023


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?


More information about the postgis-users mailing list