From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
Cc: | Robert Wojciechowski <robertw(at)expressyard(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Change sort order on UUIDs? |
Date: | 2007-06-14 21:22:03 |
Message-ID: | 20701.1181856123@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Heikki Linnakangas <heikki(at)enterprisedb(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Wojciechowski | 2007-06-14 21:26:06 | Re: Change sort order on UUIDs? |
Previous Message | Heikki Linnakangas | 2007-06-14 21:02:01 | Re: Change sort order on UUIDs? |