Re: Inconsistent string comparison using modified ICU collations - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Inconsistent string comparison using modified ICU collations
Date
Msg-id e55e987a4cf8fa36b5834951b10c43bc88e4b678.camel@j-davis.com
Whole thread Raw
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Robins Tharakan
Date:
Subject: Re: Convert sepgsql tests to TAP
Next
From: James Hunter
Date:
Subject: Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators