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

From Tom Lane
Subject Re: Change sort order on UUIDs?
Date
Msg-id 20701.1181856123@sss.pgh.pa.us
Whole thread Raw
In response to Re: Change sort order on UUIDs?  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Change sort order on UUIDs?  ("Robert Wojciechowski" <robertw@expressyard.com>)
List pgsql-hackers
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> I believe he means that with his modified comparison function, when 
> inserting a series of UUIDs with increasing time-fields, the index keys 
> are always inserted to the rightmost page, which gives a more tightly 
> packed index than scattered inserts all-around the index.

Hm.  Still, given that that benefit would only accrue for one version of
uuid generation, it's a pretty weak argument.

The concrete reason for not changing it is that the sort ordering of
uuids would then look quite unnatural compared to the display format.
Which would provoke confusion and bug reports...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Change sort order on UUIDs?
Next
From: "Robert Wojciechowski"
Date:
Subject: Re: Change sort order on UUIDs?