Postgres Pro
Downloads
Home   >   mailing lists

Re: Change sort order on UUIDs? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Change sort order on UUIDs?
Date
Msg-id 20332.1181854208@sss.pgh.pa.us
Whole thread Raw
In response to Change sort order on UUIDs?  ("Robert Wojciechowski" <robertw@expressyard.com>)
Responses Re: Change sort order on UUIDs?  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
Tree view 
"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 by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: tsearch_core patch: permissions and security issues
Next
From: Heikki Linnakangas
Date:
Subject: Re: Change sort order on UUIDs?