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?
|
Список | 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 по дате отправления: