On Jun 14, 2007, at 19:04 , [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
