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 (1 month ago)
Latest email 2026-03-13 17:33:06 (1 month ago)
Status
PG19-Final (2026-03-01 – 2026-04-09): 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