Add sort support routine for the UUID data type

Enterprise / PostgreSQL - Robert Haas [postgresql.org] - 6 November 2015 11:14 UTC

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

a76ef15 Add sort support routine for the UUID data type.
src/backend/utils/adt/uuid.c | 187 +++++++++++++++++++++++++++++++++++++++
src/include/catalog/pg_amproc.h | 1 +
src/include/catalog/pg_proc.h | 2 +
src/include/utils/builtins.h | 1 +
4 files changed, 191 insertions(+)

Upstream: git.postgresql.org

  • Share