Re: Speed up COPY TO text/CSV parsing using SIMD

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Ayoub Kazar <ayoub(dot)kazar(at)data-bene(dot)io>
Cc: KAZAR Ayoub <ma_kazar(at)esi(dot)dz>, Andres Freund <andres(at)anarazel(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Neil Conway <neil(dot)conway(at)gmail(dot)com>, Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>, Mark Wong <markwkm(at)gmail(dot)com>, Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>
Subject: Re: Speed up COPY TO text/CSV parsing using SIMD
Date: 2026-09-03 18:21:24
Message-ID: apm6pILzsNF8lJBy@nathan
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 03, 2026 at 06:01:15PM +0200, Ayoub Kazar wrote:
> After looking into more test cases, the opportunity here isn't as big as it
> was for COPY FROM in general cases, yet i have seen good performance gains
> show up in most cases, and avoiding regressions elsewhere adds some
> complexity, there's also the possibility to include the case of TOASTed
> attributes here ; which i think is a win.

Yeah, when I looked into this one a while ago, I couldn't find a good way
to avoid regressions. I wonder if we'll need to make some architectural
adjustments before trying again.

--
nathan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2026-09-03 18:30:23 Re: Do we want to avoid checksumming extra files in the datadir? [was: BUG #19647]
Previous Message Álvaro Herrera 2026-09-03 18:12:10 Re: Remove stale XXX comment in logical launcher