Speed up COPY FROM text/CSV parsing using SIMD

Edit
ID 5952
Title Speed up COPY FROM text/CSV parsing using SIMD
CI (CFBot) Summary
Stats (from CFBot) Patch version: v17, Patch count: 1, First patch: +184−3, All patches: +184−3
Tags Performance
Created 2025-08-07 05:06:54
Last modified 2026-03-13 16:08:22 (5 days ago)
Latest email 2026-03-13 17:33:06 (5 days ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Committed
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
Target version 19
Authors Shinya Kato (shinyakato)
Reviewers Nathan Bossart (bossartn), Ayoub Kazar (kaz)Become reviewer
Committer Nathan Bossart (bossartn)
Links
Emails
Speed up COPY FROM text/CSV parsing using SIMD
First at 2025-08-07 01:48:30 by Shinya Kato <shinya11.kato at gmail.com>
Latest at 2026-03-13 17:33:06 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (test_simd_copy_boundaries.sql) at 2026-03-13 15:29:35 from "Greg Burd" <greg at burd.me>
    Attachment (test_simd_copy_boundaries.sql) at 2026-03-13 15:29:35 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v17-0001-Optimize-COPY-FROM-FORMAT-text-csv-using-SIMD.patch) at 2026-03-13 14:05:13 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Optimize-COPY-FROM-FORMAT-text-csv-using-SIMD.patch) at 2026-03-13 11:57:48 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Optimize-COPY-FROM-FORMAT-text-csv-using-SIMD.patch) at 2026-03-12 17:37:14 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2026-03-11 19:22:18 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2026-03-11 11:36:46 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2026-03-10 12:35:30 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2026-03-04 15:15:53 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2026-02-23 09:10:44 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Speedup-COPY-FROM-with-additional-function-inlini.patch) at 2026-02-20 10:01:27 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Speedup-COPY-FROM-with-additional-function-inlini.patch) at 2026-02-18 21:26:14 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2026-02-13 11:45:30 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2026-02-11 13:27:50 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (0001-COPY-from-SIMD-v3-with-line_buf-periodic-refill.patch) at 2026-01-31 16:20:58 from KAZAR Ayoub <ma_kazar at esi.dz> (Patch: Yes)
    Attachment (proba-spec-chars-chunk.png) at 2026-01-22 19:32:43 from KAZAR Ayoub <ma_kazar at esi.dz> (Patch: No)
    Attachment (simd_copy_performance_2025_01_06.png) at 2026-01-06 20:05:05 from Manni Wood <manni.wood at enterprisedb.com> (Patch: No)
    Attachment (0005-Speed-up-COPY-TO-text-CSV-using-SIMD.patch) at 2025-12-24 15:07:55 from KAZAR Ayoub <ma_kazar at esi.dz> (Patch: Yes)
    Attachment (manni-simd-copy-bench-v1.2.1.sh) at 2025-12-12 23:09:05 from Manni Wood <manni.wood at enterprisedb.com> (Patch: No)
    Attachment (v4.2-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2025-12-10 11:59:41 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v4.1-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2025-12-09 13:40:19 from Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (test.sh.txt) at 2025-12-06 01:39:56 from Manni Wood <manni.wood at enterprisedb.com> (Patch: No)
    Attachment (copyfromparse-constant.asm) at 2025-11-26 11:50:58 from KAZAR Ayoub <ma_kazar at esi.dz> (Patch: No)
    Attachment (v3-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2025-10-16 14:29:36 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (COPY-SIMD-add-heuristic-to-avoid-regression-on-sm.txt) at 2025-08-19 12:33:38 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (simd-copy-from-bench.sql) at 2025-08-14 14:59:55 from KAZAR Ayoub <ma_kazar at esi.dz> (Patch: No)
    Attachment (v2-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2025-08-13 06:21:06 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Feedback.txt) at 2025-08-11 08:52:25 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (Feedback.txt) at 2025-08-07 11:15:06 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Speed-up-COPY-FROM-text-CSV-parsing-using-SIMD.patch) at 2025-08-07 01:48:30 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
History
When Who What
2026-03-13 16:08:22 Nathan Bossart (bossartn) Closed in commitfest PG19-Final with status: Committed
2026-03-10 17:10:44 Nathan Bossart (bossartn) New status: Ready for Committer
2026-02-23 09:46:32 CFbot Patch does not need rebase anymore
2026-02-22 05:31:26 CFbot Patch needs rebase
2026-02-01 00:00:08 CFbot Moved from CF PG19-4 to CF PG19-Final
2025-11-18 20:52:28 Ayoub Kazar (kaz) Added kaz as reviewer
2025-11-18 15:11:11 Nathan Bossart (bossartn) Moved from CF PG19-2 to CF PG19-4
2025-11-18 15:10:31 Nathan Bossart (bossartn) Added bossartn as committer
2025-11-18 15:10:31 Nathan Bossart (bossartn) Added bossartn as reviewer
2025-11-18 14:19:20 Nazir Bilal Yavuz (nbyavuz) New status: Needs review
2025-10-19 12:38:50 Shinya Kato (shinyakato) Closed in commitfest PG19-2 with status: Withdrawn
2025-08-18 07:46:39 Shinya Kato (shinyakato) New status: Waiting on Author
2025-08-07 05:06:54 Shinya Kato (shinyakato) Attached mail thread CAOzEurSW8cNr6TPKsjrstnPfhf4QyQqB4tnPXGGe8N4e_v7Jig@mail.gmail.com
2025-08-07 05:06:54 Shinya Kato (shinyakato) Created patch record
Edit