[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.1
 Component:  postgis  |    Version:  2.3.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by komzpa):

 The difference I see is that my dataset is made of points. Can you check
 on points dataset? It should perform more work by getting box from point
 first.

 It feels that hash can be made of a point directly without building box
 first. Also for a point you don't need any comparsions after.

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