[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] 'UpdateGeometrySRID' not using parallel workers / processing?
From:       "Regina Obe" <lr () pcorp ! us>
Date:       2023-02-25 19:20:49
Message-ID: 000201d9494e$451b15e0$cf5141a0$ () pcorp ! us
[Download RAW message or body]

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

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]