Re: What is wrong with hashed index usage? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: What is wrong with hashed index usage?
Date
Msg-id 200206212031.g5LKVHO16683@candle.pha.pa.us
Whole thread Raw
In response to What is wrong with hashed index usage?  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
Dann Corbit wrote:
> > I was thinking of this during CREATE INDEX ... hash:
> > 
> >     NOTICE:  Hash index use is discouraged.  See the CREATE INDEX
> >     reference page for more information.
> > 
> > Does anyone else like/dislike that?
> 
> I think it might be OK temporarily, to show that there is some work that
> needs done.  When hashed indexes are fixed, the notice should be
> removed.

Oh, yes, clearly, we would remove it once we had a hash implementation
that had _any_ advantages over btree.

So, is you vote for or against the elog(NOTICE)?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: What is wrong with hashed index usage?
Next
From: "Dann Corbit"
Date:
Subject: Re: What is wrong with hashed index usage?