| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | John Naylor <johncnaylorls(at)gmail(dot)com> |
| Cc: | Nathan Bossart <nathandbossart(at)gmail(dot)com>, "Chiranmoy(dot)Bhattacharya(at)fujitsu(dot)com" <Chiranmoy(dot)Bhattacharya(at)fujitsu(dot)com>, "Devanga(dot)Susmitha(at)fujitsu(dot)com" <Devanga(dot)Susmitha(at)fujitsu(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "Ragesh(dot)Hajela(at)fujitsu(dot)com" <Ragesh(dot)Hajela(at)fujitsu(dot)com> |
| Subject: | Re: [PATCH] Hex-coding optimizations using SVE on ARM. |
| Date: | 2025-01-14 05:40:40 |
| Message-ID: | Z4X42MjRGxTpfkR3@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jan 14, 2025 at 12:27:30PM +0700, John Naylor wrote:
> We can do about as well simply by changing the nibble lookup to a byte
> lookup, which works on every compiler and architecture:
>
> select hex_encode_test(1000000, 1024);
> master:
> Time: 1158.700 ms
> v2:
> Time: 777.443 ms
>
> If we need to do much better than this, it seems better to send the
> data to the client as binary, if possible.
That's pretty cool. Complex to parse, still really cool.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jian he | 2025-01-14 05:51:20 | Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row |
| Previous Message | John Naylor | 2025-01-14 05:27:30 | Re: [PATCH] Hex-coding optimizations using SVE on ARM. |