Opened 5 years ago
Closed 5 years ago
#4454 closed enhancement (fixed)
Optimize _ST_OrderingEquals by using gserialized_cmp
Reported by: | Algunenano | Owned by: | Algunenano |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 3.0.0 |
Component: | postgis | Version: | master |
Keywords: | Cc: |
Description
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)
Note:
See TracTickets
for help on using tickets.
In 17601: