[postgis-tickets] [PostGIS] #3864: Sorting by geometry is slower than sorting by geohash

[PostGIS]

#3864: Sorting by geometry is slower than sorting by geohash
----------------------+---------------------------
  Reporter:  komzpa   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.4.0
 Component:  postgis  |    Version:  2.3.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by pramsey):

 I guess. You're sorting 150M things and the difference is quite small. I
 admit I'm a little surprised that geohash isn't worse since I'm pretty
 sure it has to do a lot more work to generate a geohash that is needed to
 generate one of our pretend morton keys, which makes me wonder all the
 more about the result, and whether it's actually something to do with the
 sort itself.

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