Re: Speed up COPY FROM text/CSV parsing using SIMD - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Speed up COPY FROM text/CSV parsing using SIMD
Date
Msg-id aZTr4VpcSZx7QzOq@nathan
Whole thread Raw
In response to Re: Speed up COPY FROM text/CSV parsing using SIMD  (Manni Wood <manni.wood@enterprisedb.com>)
List pgsql-hackers
On Mon, Feb 16, 2026 at 11:01:21PM -0600, Manni Wood wrote:
> Here are the results on my x86 tower and my arm raspberry pi 5:
> 
> x86 NARROW master copy from
> TXT :                 2477.022500 ms
> CSV :                 2825.095500 ms
> TXT with 1/3 escapes: 2620.575000 ms
> CSV with 1/3 quotes:  3249.058750 ms
> 
> x86 NARROW v70001 copy from
> TXT :                 2475.659000 ms  0.055046% improvement
> CSV :                 2421.976750 ms  14.269208% improvement
> TXT with 1/3 escapes: 2660.953750 ms  -1.540836% regression
> CSV with 1/3 quotes:  3255.546750 ms  -0.199689% regression
> 
> x86 NARROW v70002 copy from
> TXT :                 2481.372250 ms  -0.175604% regression
> CSV :                 2437.541250 ms  13.718271% improvement
> TXT with 1/3 escapes: 2646.300000 ms  -0.981655% regression
> CSV with 1/3 quotes:  3202.014500 ms  1.447935% improvement
> 
> 
> arm NARROW master copy from
> TXT :                 2294.270500 ms
> CSV :                 2085.839000 ms
> TXT with 1/3 escapes: 2467.966000 ms
> CSV with 1/3 quotes:  2485.533000 ms
> 
> arm NARROW v70001 copy from
> TXT :                 1982.497500 ms  13.589200% improvement
> CSV :                 2005.829500 ms  3.835843% improvement
> TXT with 1/3 escapes: 2111.778250 ms  14.432442% improvement
> CSV with 1/3 quotes:  2441.370000 ms  1.776802% improvement
> 
> arm NARROW v70002 copy from
> TXT :                 1975.982250 ms  13.873179% improvement
> CSV :                 2022.744000 ms  3.024922% improvement
> TXT with 1/3 escapes: 2080.273000 ms  15.709009% improvement
> CSV with 1/3 quotes:  2476.819000 ms  0.350589% improvement

Thanks.  I don't see anything too terribly concerning here, but we should
still plan to redo these tests once the patch is ready for commit.

-- 
nathan



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: add assertion for palloc in signal handlers
Next
From: Michael Paquier
Date:
Subject: One-off with syscache ID in get_catalog_object_by_oid_extended()