From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
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>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: What is wrong with hashed index usage? |
Date: | 2002-06-21 20:34:57 |
Message-ID: | D90A5A6C612A39408103E6ECDD77B82920CFC4@voyager.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Friday, June 21, 2002 1:31 PM
> To: Dann Corbit
> Cc: Tom Lane; Neil Conway; mloftis(at)wgops(dot)com;
> pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] What is wrong with hashed index usage?
>
>
> 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)?
I will defer to the preference of the others. I lean ever so slightly
towards the notice, because it is very unusual for hashed index not to
be faster for single item lookup.
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2002-06-21 21:13:10 | Re: Reduce heap tuple header size |
Previous Message | Bruce Momjian | 2002-06-21 20:31:17 | Re: What is wrong with hashed index usage? |