Re: speed up text_position() for utf-8

From: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: speed up text_position() for utf-8
Date: 2022-02-02 20:20:56
Message-ID: CAFBsxsH3Yw61WUfARYo518-ABNYbA6AYsdGpCScHAbenBBh4ng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:

> I tried this test on a newer CPU, and 0003 had no regression. Both
> systems used gcc 11.2. Rather than try to figure out why an experiment
> had unexpected behavior, I plan to test 0001 and 0002 on a couple
> different compilers/architectures and call it a day. It's also worth
> noting that 0002 by itself seemed to be decently faster on the newer
> machine, but not as fast as 0001 and 0002 together.

I tested four machines with various combinations of patches, and it
seems the only thing they all agree on is that 0002 is a decent
improvement (full results attached). The others can be faster or
slower. 0002 also simplifies things, so it has that going for it. I
plan to commit that this week unless there are objections.
--
John Naylor
EDB: http://www.enterprisedb.com

Attachment Content-Type Size
test-textpos-20220202.txt text/plain 1.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Dilger 2022-02-02 20:23:26 Re: CREATEROLE and role ownership hierarchies
Previous Message Stephen Frost 2022-02-02 19:52:07 Re: CREATEROLE and role ownership hierarchies