[rathel]

Same with PostgreSQL:

https://www.paulnorman.ca/blog/2016/05/improve-your-st-geoha...

[rlucas]

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