[postgis-tickets] [PostGIS] #4453: Optimize ST_IsEmpty by avoiding deserialization

[PostGIS]

#4453: Optimize ST_IsEmpty by avoiding deserialization
-------------------------+---------------------------
 Reporter:  Algunenano   |      Owner:  Algunenano
     Type:  enhancement  |     Status:  assigned
 Priority:  medium       |  Milestone:  PostGIS 3.0.0
Component:  postgis      |    Version:  trunk
 Keywords:               |
-------------------------+---------------------------
 As <subject> says, there is no need to deserialize a geometry to know if
 it's empty.

 {{{
 EXPLAIN ANALYZE Select ST_IsEmpty(the_geom_webmercator) from
 benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293;
 }}}

 Before:
 {{{
 number of transactions actually processed: 98
 latency average = 204.691 ms
 }}}

 After:
 {{{
 number of transactions actually processed: 120
 latency average = 167.220 ms
 }}}

 GH PR: https://github.com/postgis/postgis/pull/442

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