On Jun 14, 2007, at 19:04 , [EMAIL PROTECTED] wrote:

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


Reply via email to