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

PostGIS trac at osgeo.org
Mon Feb 22 09:55:31 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):

 Hm, so maybe this is not to do with the GEOS interrupt at all, but more to
 do with the kinds of interrupt we're working with at the PostGIS layer. I
 *think* that restart sends kind of a "gentle interrupt", perhaps the issue
 is that we only respond to a harder one (whatever the analogue to a ctrl-C
 in psql is). I did find interrupt handling code in GEOS in the main noding
 routines, so it's unlikely to wait very long to hit a handler.

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