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:[email protected]] On Behalf > Of Marco Boeringa > Sent: Saturday, February 25, 2023 8:05 AM > To: [email protected] > 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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
