Re: Remove lossy-operator RECHECK flag? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Remove lossy-operator RECHECK flag?
Date
Msg-id 19670.1208197731@sss.pgh.pa.us
Whole thread Raw
In response to Re: Remove lossy-operator RECHECK flag?  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Remove lossy-operator RECHECK flag?  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
Teodor Sigaev <teodor@sigaev.ru> writes:
>> By the argument that it's better to break things obviously than to
>> break them subtly, risking case 4 seems more attractive than risking
>> case 2.

> The single thought is: usually, it's very hard to see that query returns more 
> results that it should be. It doesn't matter for fulltext search (and it has 
> very good chance to stay unnoticed forever because wrong rows will be sorted 
> down by ranking function, although performance will decrease.

Hmm ... that's a good point.  And the performance loss that I'm
complaining about is probably not large, unless you've got a *really*
expensive operator.  Maybe we should leave it as-is.

Anybody else have an opinion?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Remove lossy-operator RECHECK flag?
Next
From: Heikki Linnakangas
Date:
Subject: Re: Remove lossy-operator RECHECK flag?