[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 Algunenano):

 I've moved the CFLAGS in the postgis module to `PG_CPPFLAGS` as they were
 being ignored or overwritten when compiling with JIT support.

 Now I have a bunch of files in `/usr/lib/postgresql/bitcode/` and it
 appears to work correctly:
 {{{
 cartodb_dev_user_3e4a6fc6-4137-4c59-bc63-066f80efb90e_db=# SET
 jit_above_cost = 10;
 SET
 cartodb_dev_user_3e4a6fc6-4137-4c59-bc63-066f80efb90e_db=# SET
 jit_inline_above_cost = 10;
 SET
 cartodb_dev_user_3e4a6fc6-4137-4c59-bc63-066f80efb90e_db=# SET
 jit_optimize_above_cost = 10;
 SET
 cartodb_dev_user_3e4a6fc6-4137-4c59-bc63-066f80efb90e_db=# EXPLAIN ANALYZE
 SELECT
 ST_AsTWKB(ST_Simplify(ST_RemoveRepeatedPoints("the_geom_webmercator",10000),10000,true),-4)
 AS geom FROM (SELECT * FROM yellow_1m) as cdbq WHERE
 "the_geom_webmercator" && ST_SetSRID('BOX3D(-20037508.3
 -20037508.3,20037508.3 20037508.3)'::box3d, 3857);
 QUERY PLAN

 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ------------------------------------------
  Seq Scan on yellow_1m  (cost=0.00..48301.98 rows=999999 width=32) (actual
 time=104.892..760.779 rows=985785 loops=1)
    Filter: (the_geom_webmercator &&
 '01030000A0110F00000100000005000000CDCCCC44F81B73C1CDCCCC44F81B73C10000000000000000CDCCCC44F81B73C1CDCCCC44F81B73410000000000000000CDCCCC44F81B7341CDCCCC44F81B73410000000000000000CDCCCC44F81B7341CDCCCC44F81B73C10000000000000000CDCCCC44F81B73C1CDC
 CCC44F81B73C10000000000000000'::geometry)
    Rows Removed by Filter: 14214
  Planning Time: 2.969 ms
  JIT:
    Functions: 4
    Generation Time: 0.507 ms
    Inlining: true
    Inlining Time: 42.497 ms
    Optimization: true
    Optimization Time: 42.008 ms
    Emission Time: 17.450 ms
  Execution Time: 835.961 ms
 (13 rows)

 cartodb_dev_user_3e4a6fc6-4137-4c59-bc63-066f80efb90e_db=#
 }}}

 `liblwgeom` functions are not included since the library isn't compiled
 using PGXS and right now I don't know if it'd be useful. I'm leaving this
 issue open until I can investigate further, but feel free to close it if
 you think the job is done.

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