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

From Larry Rosenman
Subject Re: What is wrong with hashed index usage?
Date
Msg-id 1024690164.751.54.camel@lerlaptop
Whole thread Raw
In response to Re: What is wrong with hashed index usage?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: What is wrong with hashed index usage?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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. 

-- 
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



pgsql-hackers by date:

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