Re: Nasty problem in hash indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Nasty problem in hash indexes
Date
Msg-id 25074.1062131920@sss.pgh.pa.us
Whole thread Raw
In response to Re: Nasty problem in hash indexes  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Nasty problem in hash indexes
List pgsql-hackers
"scott.marlowe" <scott.marlowe@ihs.com> writes:
> On Thu, 28 Aug 2003, Neil Conway wrote:
>> On Thu, Aug 28, 2003 at 05:37:39PM -0400, Tom Lane wrote:
>>> <shrug> Who's to say?  We've found bugs in the btree logic recently,
>>> too.
>> 
>> I'd rather print a loud warning when a hash index is created, but keep
>> the code in the tree, than just remove it entirely.

> Postgresql's philosophy has always seemed to be correctness first, 
> convenience and performance second.

I agree --- we either fix this bug or remove hash indexes.  There's no
third choice.  However, I don't agree with killing hash indexes just
because there *might* be more bugs in them.  If we have an impractical-
to-fix bug in front of us, then it's time for harsh measures, but
otherwise ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Nasty problem in hash indexes
Next
From: "scott.marlowe"
Date:
Subject: Re: Nasty problem in hash indexes