Re: What is wrong with hashed index usage?

On Fri, 2002-06-21 at 15:12, Bruce Momjian wrote:
> Larry Rosenman wrote:
> > On Fri, 2002-06-21 at 11:51, Bruce Momjian wrote:
> > > Tom Lane wrote:
> > > > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > 
> > > 
> > > > 
> > > > > How about an elog(NOTICE) for hash use?
> > > > 
> > > > I don't think that's appropriate.
> > > 
> > > 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 dislike it.  Some clients/dba's will wonder why we even have them. 
> > 
> > Why should we bug the DBA on EVERY index that is a hash? 
> > 
> > I know I personally hate the FreeBSD linker warnings about certain
> > functions, and don't like that precedent. 
> 
> OK, that's enough of a negative vote for me.  So you feel the
> documentation change is enough?  Tom thinks so too.
Yup.

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749