Request a Demo
Home   >   mailing lists

Re: [PATCH v1 1/1] PostgreSQL Patch: AVX-Optimized ASCII Validation - Mailing list pgsql-hackers

From John Naylor
Subject Re: [PATCH v1 1/1] PostgreSQL Patch: AVX-Optimized ASCII Validation
Date
Msg-id CANWCAZZnXjwMC=W5p5=rUuyoCDZWPa5qESx++7t+62XKAq899A@mail.gmail.com
Whole thread Raw
In response to [PATCH v1 1/1] PostgreSQL Patch: AVX-Optimized ASCII Validation  ("Pickett, Eshe N" <eshe.n.pickett@intel.com>)
List pgsql-hackers
Tree view 
On Tue, Nov 4, 2025 at 2:45 PM Pickett, Eshe N <eshe.n.pickett@intel.com> wrote:
> This patch series introduces Intel AVX2 and AVX-512 optimized ASCII validation
>
> for PostgreSQL's UTF-8 processing pipeline, providing significant performance
>
> improvements for text-heavy workloads through vectorized string validation.

We already use SSE2/Neon here, and and a good compiler can unroll 2
vectors to work on 32-bytes per loop iteration. Profiles of COPY FROM
should not show ASCII validation to be a large part of the profile
anymore. The bottlenecks are most likely elsewhere. I don't believe
this is worth it.

--
John Naylor
Amazon Web Services

pgsql-hackers by date:

Previous
From: Mats Kindahl
Date:
Subject: Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py
Next
From: Chao Li
Date:
Subject: Re: [PATCH] Add pretty formatting to pg_get_triggerdef