[postgis-tickets] [PostGIS] #4454: Optimize _ST_OrderingEquals by using gserialized_cmp

[PostGIS]

#4454: Optimize _ST_OrderingEquals by using gserialized_cmp
-------------------------+---------------------------
 Reporter:  Algunenano   |      Owner:  Algunenano
     Type:  enhancement  |     Status:  assigned
 Priority:  medium       |  Milestone:  PostGIS 3.0.0
Component:  postgis      |    Version:  trunk
 Keywords:               |
-------------------------+---------------------------
 Same idea as https://trac.osgeo.org/postgis/ticket/4453 but for
 ST_OrderingEquals since we already have gserialized_cmp to do this.

 Query:
 I'm avoiding ST_OrderingEquals and using _ST_OrderingEquals on purpose to
 check the impact on that change alone:
 {{{
 Select * from all_month INNER JOIN all_month b ON
 _ST_OrderingEquals(all_month.the_geom, b.the_geom);
 }}}



 Before:
 {{{
 Time: 27684.750 ms (00:27.685)
 }}}

 After:
 {{{
 Time: 13964.775 ms (00:13.965)
 }}}

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

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