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

From: Mark Wong <markwkm(at)gmail(dot)com>
To: Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>
Cc: Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>, KAZAR Ayoub <ma_kazar(at)esi(dot)dz>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
Date: 2026-01-13 19:12:33
Message-ID: aWaZIWAU_wIHg7FO@o
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jan 09, 2026 at 05:21:45PM +0300, Nazir Bilal Yavuz wrote:
> Were you able to understand why Mark's benchmark results are different
> from ours?

Not yet... I had some guesses, which is why I suggested the processor pinning
and using a ramdisk. But we haven't tried applying all of those to my laptop,
which has 3 core types, or the POWER system, which may be interesting to use a
ram disk on.

I'm curious though, and admittedly haven't tried looking myself yet, about how
the SIMD calls might look across different processor architectures. We'll try
to get that on the POWER system soon...

Regards,
Mark
--
Mark Wong <markwkm(at)gmail(dot)com>
EDB https://enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nico Williams 2026-01-13 19:17:39 Re: [oauth] SASL mechanisms
Previous Message Jacob Champion 2026-01-13 18:48:36 Re: pg_plan_advice