Re: Remove lossy-operator RECHECK flag?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Remove lossy-operator RECHECK flag?
Дата
Msg-id 19670.1208197731@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Remove lossy-operator RECHECK flag?  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: Remove lossy-operator RECHECK flag?  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: Remove lossy-operator RECHECK flag?
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Remove lossy-operator RECHECK flag?