Re: Degression (PG10 > 11, 12 or 13) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Degression (PG10 > 11, 12 or 13)
Date
Msg-id 1990049.1622219094@sss.pgh.pa.us
Whole thread Raw
In response to Re: Degression (PG10 > 11, 12 or 13)  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Degression (PG10 > 11, 12 or 13)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Add ZSON extension to /contrib/
Next
From: Justin Pryzby
Date:
Subject: Re: terminate called after throwing an instance of 'std::bad_alloc'