Neil Conway wrote: > On Thu, 25 Apr 2002 16:38:00 -0400 (EDT) > "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > > > > Nice report. I think we should start thinking of hiding the hash option > > from users, or warn them more forcefully, rather than hold it out as a > > possible option for them. > > Why not do something Peter E. suggested earlier: if the functionality of > hash indexes is a subset of that offered by btrees, it might be good to > remove the hash index code and treat USING 'hash' as an alias for > USING 'btree'?
I hate to do that because it makes people think something special is happening for hash, but it isn't. We could throw an elog(NOTICE) stating that hash is not recommended and btree is faster, or something like that. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
