Re: Rework of collation code, extensibility

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Rework of collation code, extensibility
Дата
Msg-id 23b8e1f917739be889e320a407316832cb1bf8f1.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: Rework of collation code, extensibility  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
On Fri, 2023-01-20 at 12:54 -0800, Jeff Davis wrote:
> Both of these are surprising, and I haven't investigated deeply yet.

It's just because autoconf defaults to -O2 and meson to -O3, at least
on my machine. It turns out that, at -O2, master and the refactoring
branch are even; but at -O3, both get faster, and the refactoring pulls
ahead by a few percentage points.

At least that's what's happening for en-US-x-icu on UTF-8 with my test
data set. I didn't see much of a difference in other situations, but I
didn't retest those other situations this time around.

We should still look into why disabling abbreviated keys improves
performance in some cases. Maybe we need a GUC for that?


--
Jeff Davis
PostgreSQL Contributor Team - AWS





В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Introduce a new view for checkpointer related stats
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?