public inbox for [email protected]
help / color / mirror / Atom feedFrom: Joe Conway <[email protected]>
To: Thomas Munro <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: Alexey Borschev <[email protected]>
Cc: [email protected]
Subject: Re: Slow performance of collate "en_US.utf8"
Date: Fri, 28 Feb 2025 19:11:13 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+hUKGK+JYNdh6i9PHHVJf6GuTyCJCf5KFcN4atyTK7ikJHJFw@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<[email protected]>
<CA+hUKGK+JYNdh6i9PHHVJf6GuTyCJCf5KFcN4atyTK7ikJHJFw@mail.gmail.com>
On 2/28/25 17:49, Thomas Munro wrote:
> On Sat, Mar 1, 2025 at 9:03 AM Joe Conway <[email protected]> wrote:
>> On 2/28/25 09:16, Laurenz Albe wrote:
>> > On Thu, 2025-02-27 at 16:54 +0300, Alexey Borschev wrote:
>> >> I see poor performance of text sorting of collate "en_US.utf8" in PG 17.4.
>> >
>> > I'd say that you would have to complain to the authors of the
>> > GNU C library, which provides this collation.
>>
>> Yep -- glibc starting with version 2.21 has a massive performance
>> regression for certain cases and the glibc folks have basically said
>> they will not fix it. If you try the same thing on RHEL 7.x with glibc
>> 2.17 it will perform about the same as ICU.
>
> I've idly wondered if this is the culprit, do you know?
>
> https://github.com/bminor/glibc/commit/0742aef6e52a935f9ccd69594831b56d807feef3
Yes, that was definitely the one that caused the regression. Note that
if you look closely you will find there is a revert of that patch on
glibc on certain distros. But not on RHEL and RHEL-alike.
Someone else pointed out this thread to me:
https://sourceware.org/bugzilla/show_bug.cgi?id=18441
Note the last message on that thread:
8<--------------
Carlos O'Donell 2019-05-09 20:44:56 UTC
(In reply to vectoroc from comment #13)
> Hello. Is there any chance that the issues will be fixed? Unfortunately
> PostgreSQL Is unable to use ICU some base features (e.g in analyze
> operation).
We haven't had anyone working on strcoll_l performance improvements. So
it's unlikely that this will get merged or reviewed any time soon.
8<--------------
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Slow performance of collate "en_US.utf8"
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox