pgsql: Add sort support routine for the UUID data type.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема pgsql: Add sort support routine for the UUID data type.
Дата
Msg-id E1ZukcG-0000re-G0@gemulon.postgresql.org
обсуждение исходный текст
Список 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(+)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: pgsql: Set include_realm=1 default in parse_hba_line
Следующее
От: Robert Haas
Дата:
Сообщение: pgsql: Remove unnecessary cast in previous commit.