[postgis-tickets] [PostGIS] #4676: Use PG_GETARG_GSERIALIZED_P_SLICE to access geometry headers

[PostGIS]

#4676: Use PG_GETARG_GSERIALIZED_P_SLICE to access geometry headers
--------------------------+---------------------------
  Reporter:  Raúl Marín   |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 3.1.0
 Component:  postgis      |    Version:  master
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by Raúl Marín):

 Another example that shows how much of an impact can this make with big
 datasets:

 {{{
 explain analyze Select a.the_geom && b.the_geom from
 benchmark_4c7214d90a79aa6760367a084a4d4a2f61fbe1c6cc4f7f9e76020 a,
 benchmark_4c7214d90a79aa6760367a084a4d4a2f61fbe1c6cc4f7f9e76020 b;
 -- Before latency average = 423.047 ms
 -- After latency average = 0.886 ms
 -- Perf: 477.47x
 }}}

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