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

From:	Nathan Bossart <nathandbossart(at)gmail(dot)com>
To:	Greg Burd <greg(at)burd(dot)me>
Cc:	Nazir Bilal Yavuz <byavuz81(at)gmail(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>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Speed up COPY FROM text/CSV parsing using SIMD
Date:	2026-09-09 21:07:47
Message-ID:	aqHKo2JAYfNDUkRb@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-03-13 15:00:23 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                           2026-03-13 11:57:48 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                                                            2026-03-13 13:34:49 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                             2026-03-13 14:05:13 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                                                              2026-03-13 15:29:35 from "Greg Burd" <greg(at)burd(dot)me> 📎                                                                               2026-03-13 16:14:06 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                                2026-03-13 16:16:49 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                                 2026-03-13 17:22:25 from "Greg Burd" <greg(at)burd(dot)me>                                                                                2026-03-13 17:21:38 from "Greg Burd" <greg(at)burd(dot)me>                                                                                 2026-03-13 17:33:06 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                                  2026-08-31 14:24:47 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                                                                   2026-08-31 17:48:05 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                                    2026-09-01 04:41:20 from "Greg Burd" <greg(at)burd(dot)me>                                                                                     2026-09-01 08:17:03 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                                      2026-09-01 19:23:58 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                                       2026-09-07 16:29:25 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                                                                        2026-09-08 10:11:00 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> 📎                                                                                         2026-09-08 15:08:36 from "Greg Burd" <greg(at)burd(dot)me>                                                                                          2026-09-08 15:36:32 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                                           2026-09-08 15:58:42 from "Greg Burd" <greg(at)burd(dot)me> 📎                                                                                            2026-09-08 20:58:25 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                                             2026-09-09 10:12:45 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                                              2026-09-09 11:14:01 from "Greg Burd" <greg(at)burd(dot)me>                                                                                               2026-09-09 21:07:47 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                                         2026-09-08 15:24:59 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                                                                                          2026-09-09 10:00:46 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                              2026-03-13 15:58:49 from Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>                                                                               2026-03-13 16:08:14 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                                2026-03-13 16:13:18 from Nazir Bilal Yavuz <byavuz81(at)gmail(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

In response to

• Re: Speed up COPY FROM text/CSV parsing using SIMD at 2026-09-09 11:14:01 from Greg Burd

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Haibo Yan	2026-09-09 21:10:13	Re: addFkRecurseReferencing use unassigned fkconstraint->fk_with_period value
Previous Message	Tom Lane	2026-09-09 20:47:10	Re: CREATE SCHEMA ... CREATE DOMAIN support