[postgis-tickets] [PostGIS] #3792: ST_3DIntersects not marked as parallel safe

PostGIS trac at osgeo.org
Thu Jul 20 21:57:18 PDT 2017


#3792: ST_3DIntersects not marked as parallel safe
---------------------+---------------------------
 Reporter:  robe     |      Owner:  robe
     Type:  defect   |     Status:  assigned
 Priority:  medium   |  Milestone:  PostGIS 2.3.4
Component:  postgis  |    Version:  2.3.x
 Keywords:           |
---------------------+---------------------------
 As paranoidd noted on irc:


 {{{
 13:52:20        paranoidd:      hi, folks!
 13:53:41        paranoidd:      PostGIS newbie here, with a question
 that's possibly been answered before
 13:54:44        paranoidd:      so, I've been looking into some query
 plans and I realized that some of them involving ST_3DIntersects() were
 serializing the plan through sequential scans
 13:55:15        paranoidd:      ST_Intersects(), on the other hand,
 benefits from parallel scans
 13:55:44        paranoidd:      it looks like ST_Intersects() is marked
 PARALLEL SAFE, whereas ST_3DIntersects() is not
 13:58:38        paranoidd:      I see that
 https://trac.osgeo.org/postgis/ticket/3650 marks certain aggregate
 functions as parallel safe, so I wonder if (1) the dev team has already
 gone through a review of ST_3DIntersects() and realized that it's not
 parallel safe, or (2) a thorough review of this function is still pendi
 }}}


 I don't think there is any reason why we shouldn't mark as parallel safe.
 This needs to be done for both regular postgis and SFCGAL.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3792>
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