From: | Robert Haas <rhaas(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Add sort support routine for the UUID data type. |
Date: | 2015-11-06 17:15:56 |
Message-ID: | E1ZukcG-0000re-G0@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/a76ef15d9fc9207a0758e8d6f6700dc8c931a934
Modified Files
--------------
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(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2015-11-06 17:18:10 | pgsql: Remove unnecessary cast in previous commit. |
Previous Message | Stephen Frost | 2015-11-06 16:18:46 | pgsql: Set include_realm=1 default in parse_hba_line |