[postgis-tickets] [PostGIS] #4060: PostgreSQL 11 JIT support

[PostGIS]

#4060: PostgreSQL 11 JIT support
----------------------+---------------------------
  Reporter:  komzpa   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.5.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by anarazel):

 (Andres here)

 >  This is very interesting, but as Andreas points out, we generally have
 much higher overheads, so the gains we can reap are probably small. What
 tiny thing do we do very very frequently that could be JIT'ed? Maybe the
 && operator?

 I've not looked through the code for operators or anything like that.  But
 the JIT feature does have costing logic to see whether function/operator
 inlining is beneficial, so I'd not worry too much about which functions
 can be inlinable.  I'd suggest just installing the bitcode ;)

 I notice that postgis actually does, contrary to my expectation, appears
 to use PGXS
 https://trac.osgeo.org/postgis/browser/trunk/postgis/Makefile.in
 so it's possible that the PGXS support does all the necessary things if
 postgres is compiled with LLVM support. Also possible that some of the
 bigger complexity, in comparison to the average contrib/ extension,
 prevents that from working.

 Would be good if somebody tried ;). You should see
 $pkglibdir/postgis-$major-$minor/ being filled with things.

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