On Thu, 2003-11-13 at 10:01, Tom Lane wrote:
> Mark Harrison <[EMAIL PROTECTED]> writes:
> > Since these are all unique things, and will only be tested for
> > equality, I am guessing that making a hash index will be better
> > than making a btree index.
>
> You are mistaken. If there were any real value in that, we'd offer
> an easier way to do it.
>
> regards, tom lane
Hash indices also have locking restrictions that make them less useful
in most applications.
Stephen
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
