Re: Speed up collation cache

Поиск
Список
Период
Сортировка
От Andreas Karlsson
Тема Re: Speed up collation cache
Дата
Msg-id e8d8c09e-7dc6-4306-bbb8-279dd24acaeb@proxel.se
обсуждение исходный текст
Ответ на Re: Speed up collation cache  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
On 7/26/24 11:00 PM, Jeff Davis wrote:
> Results (in ms):
> 
>                "C"   "libc_c"   overhead
>     master:    6350     7855     24%
>     v4-0001:   6091     6324      4%

I got more overhead in my quick benchmarking when I ran the same 
benchmark. Also tried your idea with caching the last lookup (PoC patch 
attached) and it basically removed all overhead, but I guess it will not 
help if you have two different non.default locales in the same query.

             "C"   "libc_c" overhead
before:     6695  8376     25%
after:      6605  7340     11%
cache last: 6618  6677      1%

But even without that extra optimization I think this patch is worth 
merging and the patch is small, simple and clean and easy to understand 
and a just a clear speed up. Feels like a no brainer. I think that it is 
ready for committer.

And then we can discuss after committing if an additional cache of the 
last locale is worth it or not.

Andreas
Вложения

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

Предыдущее
От: Joseph Koshakow
Дата:
Сообщение: Re: Fix overflow in pg_size_pretty
Следующее
От: David Rowley
Дата:
Сообщение: Re: Fix overflow in pg_size_pretty