| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | mark(at)mark(dot)mielke(dot)cc |
| Cc: | Robert Wojciechowski <robertw(at)expressyard(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Change sort order on UUIDs? |
| Date: | 2007-06-15 14:40:29 |
| Message-ID: | 45CB711F-7A29-406F-BBAE-75E1FB0276BE@seespotcode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Jun 14, 2007, at 19:04 , mark(at)mark(dot)mielke(dot)cc wrote:
> For UUID, I
> would value random access before sequential performance. Why would
> anybody scan UUID through the index in "sequential" order?
AIUI, to allow UUID columns to be indexed using BTREE, there needs to
be some ordering defined. So regardless of what this ordering is,
doesn't there need to be some order? And as a (primary?) purpose of
UUIDs is to be (universally) unique, and the implementation of
uniqueness constraints in PostgreSQL is based on BTREE indexes, this
makes the necessity of ordering doubly so. Or have I missed something?
Michael Glaesemann
grzm seespotcode net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Wojciechowski | 2007-06-15 14:40:55 | Re: Change sort order on UUIDs? |
| Previous Message | Tom Lane | 2007-06-15 14:36:15 | Re: tsearch_core patch: permissions and security issues |