Re: Change sort order on UUIDs?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Change sort order on UUIDs?
Дата
Msg-id 20332.1181854208@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Change sort order on UUIDs?  ("Robert Wojciechowski" <robertw@expressyard.com>)
Ответы Re: Change sort order on UUIDs?  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-hackers
"Robert Wojciechowski" <robertw@expressyard.com> writes:
> I've been testing the new UUID functionality in 8.3dev and noticed that
> UUIDs are sorted using memcmp in their default in-memory layout,
> ...
> When done that way, you're going to see a lot of index B-tree
> fragmentation with even DCE 1.1 (ISO/IEC 11578:1996) time based UUIDs,

This claim seems like nonsense.  Btrees don't care about the ordering
details of what they index.
        regards, tom lane


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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: tsearch_core patch: permissions and security issues
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Change sort order on UUIDs?