id summary reporter owner description type status priority milestone component version resolution keywords cc 3883 Make B-Tree sorting blazingly fast komzpa komzpa " - make gserialized_get_sort_hash function; - make it return least possible value on EMPTY; - make it read not box, but first coordinate of gserialized. This way no geography/geometry branching is needed, and it should be faster than getting a float-rounded box center for geometries that don't store it; - make fast path for complete equality for fast GROUP BY in gserizlized_cmp; - create sortsupport function that will employ gserialized_get_sort_hash and full equality fast path; - investigate when to abort abbreviated compare in sort. (this is going to happen more often on 32bit machines, as sortsupport key will be 32bit, containing half of 64bit key). " enhancement closed medium PostGIS 3.0.0 postgis master fixed