[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:  closed
  Priority:  high         |  Milestone:  PostGIS 2.3.0
 Component:  postgis      |    Version:  trunk
Resolution:  fixed        |   Keywords:
--------------------------+---------------------------

Comment (by dbaston):

 I ran a geography version of the same test scenario.  It looks like same
 issue is present (deserializing to compute a box), but it's much less
 significant, around 10% of query time.  It looks like the relevant place
 to change would be in libpgcommon/gserialized_gist.c:289.  Of course, you
 still have to compute the box, so maybe you could bring it down to
 6-8%...doesn't quite seem worth it.

 I attached a copy of my callgrind output if anyone's interested.  I
 recently discovered kcachegrind, which is a really nice viewer for these
 files.

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