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

PostGIS trac at osgeo.org
Mon Feb 22 10:21:04 PST 2021


#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):

 Yeah, a fast shutdown is a SIGINT, so maybe I'm just totally wrong, and in
 fact you've just found a case that doesn't interrupt very fast in one
 place... There's definitely interrupts all through the union and buffer
 code, but there's also some places (overlay validation) that could maybe
 run a long time? So whether you got a "fast" interrupt or not would be
 somewhat random depending on where the process happened to be when you hit
 the ctrl-c.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4857#comment:8>
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.


More information about the postgis-tickets mailing list