[postgis-users] 'UpdateGeometrySRID' not using parallel workers / processing?

[Regina Obe]

Update queries are not parallelizable and since UpdateGeometrySRID updates
data, it can't be parallelized.

That is all detailed here -
https://www.postgresql.org/docs/current/when-can-parallel-query-be-used.html



> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
Behalf
> Of Marco Boeringa
> Sent: Saturday, February 25, 2023 8:05 AM
> To: postgis-users at lists.osgeo.org
> Subject: [postgis-users] 'UpdateGeometrySRID' not using parallel workers /
> processing?
> 
> Hi,
> 
> I have noticed that even on large data sets, it appears the
> 'UpdateGeometrySRID' command doesn't parallelize the processing. Now I
> have no idea if there are any technical limitations that cause or prevent
> implementing this, but it would certainly be kind of nice to see
processing
> being parallelized with huge tables stored with PostGIS geometries, as it
can
> be a lengthy process.
> 
> Marco
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users