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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Degression (PG10 > 11, 12 or 13)
Дата
Msg-id 1990049.1622219094@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Degression (PG10 > 11, 12 or 13)  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Degression (PG10 > 11, 12 or 13)  (Johannes Graën <johannes@selfnet.de>)
Список 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 по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Add ZSON extension to /contrib/
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: terminate called after throwing an instance of 'std::bad_alloc'