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

[Regina Obe]

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