[postgis-tickets] [PostGIS] #4857: Large ST_Union makes PostgreSQL temporarily unrestartable

[PostGIS]

#4857: Large ST_Union makes PostgreSQL temporarily unrestartable
-----------------------+---------------------------
  Reporter:  grassick  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  high      |  Milestone:  PostGIS 3.1.2
 Component:  postgis   |    Version:  3.1.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by pramsey):

 It's... not even a slam dunk what to fix. There's an interrupt right in
 `MCIndexNoder::intersectChains` and sure enough, when I get into that
 place where a long hang occurs after interrupt, and attach the debugger,
 that's right where the process is. Basically to fix this we'd need to move
 the interrupt deeper into the loop, but that would increase the overhead
 for all the times we're not trying to end the process.

 https://github.com/libgeos/geos/blob/e4fd106f4f66167b554389c7b441d9bc5ee89b1b/src/noding/MCIndexNoder.cpp#L77

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4857#comment:10>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.