Re: Speed up collation cache - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: Speed up collation cache
Date
Msg-id e8d8c09e-7dc6-4306-bbb8-279dd24acaeb@proxel.se
Whole thread Raw
In response to Re: Speed up collation cache  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Speed up collation cache
List 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
Attachment

pgsql-hackers by date:

Previous
From: Joseph Koshakow
Date:
Subject: Re: Fix overflow in pg_size_pretty
Next
From: David Rowley
Date:
Subject: Re: Fix overflow in pg_size_pretty