> Regina, > > If I recall, a big part of the performance for large geometries is untoasting > them but there isn't much you can do about that. I'm not sure if the > untoasted geometries are cached or not, or if they get passed to multiple > functions in the same query or if they get untoasted for each use. My > memory is old on this, has it changed in the more recent releases? > > -Steve W >
I think you are right about that for big geometries. Even the changes coming in PostGIS 3.1 far partial detoasting I don't think will help ST_Area/Perimeter of largish geometries. _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
