Re: Wrong Results from SP-GiST with Collations - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Wrong Results from SP-GiST with Collations
Date
Msg-id 26053.1523908552@sss.pgh.pa.us
Whole thread Raw
In response to Re: Wrong Results from SP-GiST with Collations  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Wrong Results from SP-GiST with Collations  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-bugs
Peter Geoghegan <pg@bowt.ie> writes:
> On Mon, Apr 16, 2018 at 12:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> True.  This way saves a few cycles, but maybe it's not worth the extra
>> code.  I think the only case where you could really notice the difference
>> is for an equality search operator, which might end up doing a lot more
>> work in non-C collations (full-blown strcoll vs memcmp).

> I don't have a full understanding of this particular problem, but it
> sounds to me that that would be a non-issue due to the equality
> fast-path added to varstr_cmp() several years ago. I microbenchmarked
> it quite extensively at the time, and concluded that it was all but
> free in cases where it didn't work out.

I'm not following --- varstr_cmp has no way to know that we only
care about equality vs inequality.  Yes, it might give back an
answer quickly when the strings are equal, but when they aren't,
it has to decide which is greater.  In this case we don't care,
so long as the search operator is "=".

            regards, tom lane


pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Wrong Results from SP-GiST with Collations
Next
From: Peter Geoghegan
Date:
Subject: Re: Wrong Results from SP-GiST with Collations