[postgis-tickets] [PostGIS] #3382: Avoid deserializing small geometries during index operations

[PostGIS]

#3382: Avoid deserializing small geometries during index operations
--------------------------+---------------------------
  Reporter:  dbaston      |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  high         |  Milestone:  PostGIS 2.3.0
 Component:  postgis      |    Version:  trunk
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by dbaston):

 Committed to trunk at r14478.

 robe, if you see a decent performance benefit from this, let me know.  It
 seems like it would be pretty simple to extend the "gserialized_peek"
 function that's behind this to handle geography points as well.  (The
 gains I was seeing were in counting intersections between 20,000 polygons
 -- TIGER faces for FIPS 25001 -- and 100,000 random points selected from
 the extent of that dataset.)

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