Re: Performance degradation in Index searches with special characters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Andrey Stikheev <andrey(dot)stikheev(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Performance degradation in Index searches with special characters
Date: 2024-10-06 18:13:14
Message-ID: 1375944.1728238394@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joe Conway <mail(at)joeconway(dot)com> writes:
> This is not surprising. There is a performance regression that started
> in glibc 2.21 with regard to sorting unicode. Test with RHEL 7.x (glibc
> 2.17) and I bet you will see comparable results to ICU. The best answer
> in the long term, IMHO, is likely to use the new built-in collation just
> released in Postgres 17.

It seems unrelated to unicode though --- I also reproduced the issue
in a database with LATIN1 encoding.

Whatever, it is pretty awful, but the place to be complaining to
is the glibc maintainers. Not much we can do about it.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shiv Iyer 2024-10-06 20:02:01 Re: Performance degradation in Index searches with special characters
Previous Message Joe Conway 2024-10-06 17:45:15 Re: Performance degradation in Index searches with special characters