Re: Performance degradation in Index searches with special characters

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Joe Conway <mail@xxxxxxxxxxxxx> 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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux