7 ms·

Same with PostgreSQL: https://www.paulnorman.ca/blog/2016/05/improve-your-st-geohash-sorting-with-these-three-simple-tricks/ https://www.paulnorman.ca/blog/201

• rlucas 4y ago
  ++ COLLATE "C" is your friend, particularly if you find yourself using a GUID or other text-y PK field.