Date: Tue, 17 Feb 2026 16:29:53 -0600
From: Nathan Bossart <nathandbossart@gmail.com>
To: Manni Wood <manni.wood@enterprisedb.com>
Cc: Nazir Bilal Yavuz <byavuz81@gmail.com>, KAZAR Ayoub <ma_kazar@esi.dz>,
	Neil Conway <neil.conway@gmail.com>,
	Andrew Dunstan <andrew@dunslane.net>,
	Shinya Kato <shinya11.kato@gmail.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
Message-ID: <aZTr4VpcSZx7QzOq@nathan>
References: <CAN55FZ2DOeLjSXE2Jos99bgHG-Zeo3KjStrSgoA8Rf=2Mu+hFA@mail.gmail.com>
 <aYZvdsXPElQvwWOA@nathan>
 <CAN55FZ1=O6TjeZM2CUT7T2tu66uJT+w3G9FiRXVs+gt_ousFxQ@mail.gmail.com>
 <aY0FL4rXUl6ykn-a@nathan>
 <CAN55FZ3g6QaiC8G4GMjdJ24egvgc-HG_xpoOztxnM_wnQNn5aw@mail.gmail.com>
 <aY-vJe_ENCB-fux9@nathan>
 <CAKWEB6p-Y54yWA5kq6OXEYV=ABdHenJ559i0MshOoYkP4i=o5A@mail.gmail.com>
 <aZNOOjyeWLv9_7fr@nathan>
 <aZNewLWZ4MbrrrLv@nathan>
 <CAKWEB6p-9cwDhnN4GKOFz0Yzqb7PtTLChH-+wjd-SNhrbiJuLA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CAKWEB6p-9cwDhnN4GKOFz0Yzqb7PtTLChH-+wjd-SNhrbiJuLA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/aZTr4VpcSZx7QzOq%40nathan>
Precedence: bulk

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