[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:  closed
  Priority:  medium   |  Milestone:  PostGIS 2.4.1
 Component:  postgis  |    Version:  2.3.x
Resolution:  fixed    |   Keywords:
----------------------+---------------------------

Comment (by pramsey):

 I still find this very hard to wrap my head around. Look at how much work
 there is in the geohash calculation function -- before any sorting can
 happen, all those expensive keys have to be calculated. So all we have
 left is the idea that somehow, in your very large sort, the cost of the
 sort itself washes out the cost of key calculation. So the sortsupport
 stuff better be the answer or I'm out of ideas; makes no sense.

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