This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold
--------------------------------------------------------------------------- Michael Glaesemann wrote: > > 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 -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend