From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, mloftis(at)wgops(dot)com, DCorbit(at)connx(dot)com, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: What is wrong with hashed index usage? |
Date: | 2002-06-21 20:13:55 |
Message-ID: | 1024690436.751.56.camel@lerlaptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)candle(dot)pha(dot)pa(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2002-06-21 20:20:18 | Re: What is wrong with hashed index usage? |
Previous Message | Bruce Momjian | 2002-06-21 20:12:23 | Re: What is wrong with hashed index usage? |