Pavel Stehule <pavel.steh...@gmail.com> writes: > pá 28. 5. 2021 v 16:12 odesílatel Johannes Graën <johan...@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