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

From:	Nathan Bossart <nathandbossart(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>, Neil Conway <neil(dot)conway(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-03-12 17:37:14
Message-ID:	abL5ylYjmopRRmvy@nathan
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2025-08-07 01:48:30 from Shinya Kato <shinya11(dot)kato(at)gmail(dot)com> 📎  2025-08-07 11:15:06 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎   2025-08-11 08:52:25 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎    2025-08-12 07:25:36 from Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>     2025-08-13 06:21:06 from Shinya Kato <shinya11(dot)kato(at)gmail(dot)com> 📎      2025-08-14 02:24:50 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>       2025-08-14 10:29:35 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>        2025-08-14 14:59:55 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz> 📎         2025-08-19 12:33:38 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎          2025-08-19 14:14:54 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>           2025-08-21 15:47:30 from Andrew Dunstan <andrew(at)dunslane(dot)net>            2025-10-16 14:29:36 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎             2025-10-18 18:46:29 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>              2025-10-18 20:01:41 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>               2025-10-21 06:17:01 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                2025-10-21 06:44:06 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                2025-10-21 18:55:07 from Nathan Bossart <nathandbossart(at)gmail(dot)com>             2025-10-18 20:01:29 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>             2025-10-20 14:02:23 from Andrew Dunstan <andrew(at)dunslane(dot)net>              2025-10-20 17:04:03 from Nathan Bossart <nathandbossart(at)gmail(dot)com>               2025-10-20 20:31:58 from Andrew Dunstan <andrew(at)dunslane(dot)net>                2025-10-20 21:09:27 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                 2025-10-21 18:40:09 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                  2025-10-22 12:33:37 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                   2025-10-22 19:24:59 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                    2025-10-29 22:22:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>                     2025-11-11 22:23:20 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                      2025-11-12 14:44:02 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                       2025-11-13 02:40:35 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                        2025-11-17 22:16:48 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                         2025-11-17 22:52:58 from Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>                          2025-11-18 08:04:35 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                           2025-11-18 14:01:00 from Andrew Dunstan <andrew(at)dunslane(dot)net>                            2025-11-18 14:20:05 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                             2025-11-19 21:01:03 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                              2025-11-20 12:55:43 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                               2025-11-21 14:48:53 from Andrew Dunstan <andrew(at)dunslane(dot)net>                               2025-11-24 21:59:21 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                2025-11-26 00:09:42 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                              2025-11-26 11:50:58 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz> 📎                               2025-11-26 14:21:46 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                2025-12-06 01:39:56 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com> 📎                                 2025-12-06 07:55:50 from Bilal Yavuz <byavuz81(at)gmail(dot)com>                                  2025-12-09 13:40:19 from Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                   2025-12-09 22:13:02 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                    2025-12-10 11:59:41 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                     2026-01-21 20:49:59 from Neil Conway <neil(dot)conway(at)gmail(dot)com>                                      2026-01-22 19:32:43 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz> 📎                                      2026-01-31 16:20:58 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz> 📎                                       2026-02-02 14:17:55 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                       2026-02-06 13:51:17 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                        2026-02-06 18:11:37 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                         2026-02-06 21:29:13 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                          2026-02-06 22:19:16 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                           2026-02-06 22:36:13 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                           2026-02-06 22:47:18 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                            2026-02-11 13:27:50 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                             2026-02-11 22:39:43 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                              2026-02-13 11:45:30 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                               2026-02-13 23:09:25 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                2026-02-14 03:34:13 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                 2026-02-16 17:04:58 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                  2026-02-16 18:15:28 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                   2026-02-17 05:01:21 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                    2026-02-17 22:29:53 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                2026-02-18 13:38:07 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                 2026-02-18 21:26:14 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                                  2026-02-18 21:54:20 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                   2026-02-19 04:02:25 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                    2026-02-19 09:01:02 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                     2026-02-19 22:37:00 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                      2026-02-20 00:09:27 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                       2026-02-20 09:50:35 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                        2026-02-20 18:15:41 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                         2026-02-23 09:10:44 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                                          2026-02-24 04:44:44 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                           2026-02-24 13:57:21 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                            2026-02-24 15:07:38 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                            2026-02-24 17:48:17 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                             2026-02-25 04:06:13 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                             2026-02-25 14:24:27 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                              2026-02-26 12:19:32 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                               2026-02-26 14:31:30 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                                2026-02-26 14:36:09 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                                 2026-02-26 15:32:21 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                                  2026-02-26 15:51:33 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                              2026-03-02 19:55:05 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                               2026-03-04 15:15:53 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                                                2026-03-05 21:25:14 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                 2026-03-06 16:59:52 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                                  2026-03-06 17:39:04 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                   2026-03-06 18:13:33 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                                    2026-03-06 18:55:26 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                     2026-03-06 21:25:46 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                                      2026-03-06 23:13:13 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                       2026-03-06 23:31:19 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                                        2026-03-08 10:31:32 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                         2026-03-08 19:45:44 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                                          2026-03-09 08:10:13 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                           2026-03-09 13:31:39 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                                            2026-03-09 13:43:00 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                2026-03-09 18:25:25 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                 2026-03-10 02:30:21 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                                  2026-03-10 11:42:28 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                 2026-03-10 12:35:30 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                                                  2026-03-10 17:10:05 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                   2026-03-11 11:36:46 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                                                    2026-03-11 12:19:18 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                                     2026-03-11 13:10:42 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                      2026-03-11 13:23:41 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                                    2026-03-11 18:09:21 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                     2026-03-11 18:49:22 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                      2026-03-11 19:02:31 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                       2026-03-11 19:22:18 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                                                        2026-03-11 20:42:38 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                         2026-03-12 10:59:53 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                          2026-03-12 17:37:14 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                                                           2026-03-13 02:39:38 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                2026-02-20 10:01:27 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                   2025-12-12 20:42:20 from Mark Wong <markwkm(at)gmail(dot)com>                                    2025-12-12 23:09:05 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com> 📎                                     2025-12-18 07:35:44 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                      2025-12-24 15:07:55 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz> 📎                                       2025-12-29 17:03:17 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                       2025-12-31 13:04:15 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                        2026-01-06 20:05:05 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com> 📎                                         2026-01-07 19:13:28 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                          2026-01-08 20:49:57 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                           2026-01-09 00:01:59 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                           2026-01-09 14:22:38 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                          2026-01-09 14:21:45 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                           2026-01-13 19:12:33 from Mark Wong <markwkm(at)gmail(dot)com>                                            2026-01-14 00:20:27 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                             2026-01-17 21:24:49 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                              2026-01-20 20:48:58 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                               2026-01-22 18:22:56 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                             2026-01-30 22:05:33 from Mark Wong <markwkm(at)gmail(dot)com>                                              2026-02-02 20:45:04 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                               2026-02-03 10:59:52 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                2026-02-03 11:02:16 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                 2026-02-03 12:06:19 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                  2026-02-04 05:38:27 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                                   2026-02-04 14:28:56 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                                                    2026-02-04 15:07:07 from Manni Wood <manni(dot)wood(at)enterprisedb(dot)com>                                         2026-01-09 14:20:54 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                        2026-01-17 20:46:52 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>                         2025-11-18 20:42:39 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>          2025-08-21 19:36:42 from KAZAR Ayoub <ma_kazar(at)esi(dot)dz>   2025-08-19 09:09:20 from Ants Aasma <ants(dot)aasma(at)cybertec(dot)at>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v15-0001-Optimize-COPY-FROM-FORMAT-text-csv-using-SIMD.patch	text/plain	8.9 KB

In response to

• Re: Speed up COPY FROM text/CSV parsing using SIMD at 2026-03-12 10:59:53 from Nazir Bilal Yavuz

Responses

• Re: Speed up COPY FROM text/CSV parsing using SIMD at 2026-03-13 02:39:38 from Manni Wood

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Bryan Green	2026-03-12 17:48:38	Re: Avoid multiple calls to memcpy (src/backend/access/index/genam.c)
Previous Message	Peter Geoghegan	2026-03-12 17:27:00	Re: index prefetching