Add sort support routine for the UUID data type.

Robert Haas <rhaas@postgresql.org>

Commit: a76ef15d9fc9207a0758e8d6f6700dc8c931a934
Author: Robert Haas <rhaas@postgresql.org>
Date: 2015-11-06T17:14:35Z
Releases: 9.6.0
Add sort support routine for the UUID data type.

This introduces a simple encoding scheme to produce abbreviated keys:
pack as many bytes of each UUID as will fit into a Datum.  On
little-endian machines, a byteswap is also performed; the abbreviated
comparator can therefore just consist of a simple 3-way unsigned integer
comparison.

The purpose of this change is to speed up sorting data on a column
of type UUID.

Peter Geoghegan

Files

PathChange+/−
src/backend/utils/adt/uuid.c modified +187 −0
src/include/catalog/pg_amproc.h modified +1 −0
src/include/catalog/pg_proc.h modified +2 −0
src/include/utils/builtins.h modified +1 −0