Fix hangs in COPY FROM (FORMAT text)

Edit

ID

Title

Fix hangs in COPY FROM (FORMAT text)

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v3, Patch count: 2, First patch: +18−4, All patches: +109−4

Tags

Bugfix

Created

2026-09-08 15:30:23

Last modified

2026-09-09 21:10:25 (1 month ago)

Latest email

2026-09-09 21:07:47 (1 month ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Committed

PG20-3 (2026-11-01 – 2026-11-30): Moved to different CF

Target version

stable

Authors

Nazir Bilal Yavuz (nbyavuz)

Reviewers

Nathan Bossart (bossartn) 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-09-09 21:07:47 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v3-0001-Fix-hangs-in-COPY-FROM-FORMAT-text.patch) at 2026-09-08 15:58:42 from "Greg Burd" <greg at burd.me>
    Attachment (v3-0001-Fix-hangs-in-COPY-FROM-FORMAT-text.patch) at 2026-09-08 15:58:42 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v2-0001-Fix-hangs-in-COPY-FROM-FORMAT-text.patch) at 2026-09-08 15:24:59 from Nathan Bossart <nathandbossart at gmail.com> (Patch: No)
    Attachment (v1-0001-Fix-COPY-SIMD-refill-blocking-on-buffered-end-mar.patch) at 2026-09-08 10:11:00 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: No)
    Attachment (reproducer.sql) at 2026-09-07 16:29:25 from Nazir Bilal Yavuz <byavuz81 at gmail.com> (Patch: No)
    Attachment (v1-0001-Make-COPY-FROM-s-SIMD-read-ahead-speculative.patch) at 2026-08-31 14:24:47 from Nathan Bossart <nathandbossart at gmail.com> (Patch: No)
    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-09-09 21:10:25	Nathan Bossart (bossartn)	Closed in commitfest PG20-2 with status: Committed
2026-09-09 21:10:25	Nathan Bossart (bossartn)	Moved from CF PG20-3 to CF PG20-2
2026-09-08 15:30:28	Nathan Bossart (bossartn)	New status: Ready for Committer
2026-09-08 15:30:27	Nathan Bossart (bossartn)	Added bossartn as reviewer
2026-09-08 15:30:25	Nathan Bossart (bossartn)	Added bossartn as committer
2026-09-08 15:30:23	Nathan Bossart (bossartn)	Attached mail thread CAOzEurSW8cNr6TPKsjrstnPfhf4QyQqB4tnPXGGe8N4e_v7Jig@mail.gmail.com
2026-09-08 15:30:23	Nathan Bossart (bossartn)	Created patch record

Edit