[postgis-users] Setting multiple columns in one UPDATE request

Regina Obe lr at pcorp.us
Mon Sep 28 11:42:53 PDT 2020

> 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.

More information about the postgis-users mailing list