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 |
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 |