[postgis-users] Long running processes and commit writing to disk

Paul Ramsey pramsey at cleverelephant.ca
Fri Apr 8 09:51:01 PDT 2022


Build your loop in plpgsql with an exception handler to write out broken cases to a side table, and your good results to an output table.

> On Apr 8, 2022, at 9:38 AM, Shaozhong SHI <shishaozhong at gmail.com> wrote:
> 
> When long running processes got disrupted, one may not see any expected result.
> 
> How to make sure that the result of each operation is saved to disk in a loop?
> 
> Regards,
> 
> David
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



More information about the postgis-users mailing list