Re: Degression (PG10 > 11, 12 or 13)

Pavel Stehule <pavel.stehule@gmail.com> writes:
> pá 28. 5. 2021 v 16:12 odesílatel Johannes Graën <johannes@selfnet.de>
> napsal:
>> When trying to upgrade an existing database from version 10 to 13 I came
>> across a degression in some existing code used by clients. Further
>> investigations showed that performance measures are similar in versions
>> 11 to 13, while in the original database on version 10 it's around 100
>> times faster. I could boil it down to perl functions used for sorting.

> Are you sure, so all databases use the same encoding and same locale?

Yeah ... I don't know too much about the performance of Perl regexps,
but it'd be plausible that it varies depending on locale setting.

            regards, tom lane