Thread: Re: Inconsistent string comparison using modified ICU collations

Re: Inconsistent string comparison using modified ICU collations

From
Jeff Davis
Date:
On Thu, 2025-01-23 at 13:29 -0800, Jeff Davis wrote:
> I had previously proposed[1] a GUC to control abbreviated keys, and
> it
> was rejected. Now that we've seen both a performance problem and a
> bug
> in the underlying dependency, perhaps we should reconsider.

Users may:

* trust libc strxfrm, or not
* trust ICU getSortKey & nextSortKeyPart, or not
* want to enable/disable abbreviated keys for testing (perf or
correctness)

And should we make the default the same as the current behavior --
trust ICU but not libc -- or should we trust neither by default?

We might need a few new GUCs here, unless someone has a better idea. I
suppose we could tie it to individual collations, but that seems worse.

Regards,
    Jeff Davis