Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w15C3-002Xhm-2U for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 16:16:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w15C2-005AUt-0S for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 16:16:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w15C1-005AUk-2H for pgsql-hackers@lists.postgresql.org; Fri, 13 Mar 2026 16:16:54 +0000 Received: from mail-oa1-x36.google.com ([2001:4860:4864:20::36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w15C0-00000001yeI-1zOm for pgsql-hackers@postgresql.org; Fri, 13 Mar 2026 16:16:53 +0000 Received: by mail-oa1-x36.google.com with SMTP id 586e51a60fabf-41708f6c3feso1529628fac.3 for ; Fri, 13 Mar 2026 09:16:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773418611; x=1774023411; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=JTcKEAXEKyB5Guyw1byHYL6npX/cOxdh1vaEXO9pD9M=; b=TF+w/h5eOpn582sbb0LHikvDxt/CyK51tW5neOgK7JT8HCRMHmlU0tDc3M38YYjx+r TW8eItcydOIzRO6q9MRLc76rabM8c9zQESUPh4JajM0ixPXmK7DOXvEzqVavIPbPwD26 VTs0/YpoV38B3FDFYpFQvWZhtLvKo9DyohS9nllRd60fCZ4Y+fVgr2hU2o5Ry+xTOosv nxkueK8+0j37ARphe95q9nJMHDWGTVIKqBt3XPCkE+zvpS5/85WHKbiPcKDLDKvQ1IOx HmCkbRm3SY0p4Lg2TfMoQYAsZMaYaK32mMnebnOOutLdiTij6IuSAkYt9m8kYLm7U+XY I67Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773418611; x=1774023411; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=JTcKEAXEKyB5Guyw1byHYL6npX/cOxdh1vaEXO9pD9M=; b=QX905mvh8Hd0FJn22cfVvSVJ1x2MzbkjO/Y6M+TXx6tfKjxdC5gMB3xbCBbPkFfsBa fEOxgNO5RyNx/DRKAfAkw13RPQSKKi9MLP/eatOKEfCVPoJdsRkUyOxu39wupXgHflTD 2IZnzQXoEDh0UcOnLjI5mLHD3OYvVjpIOf7W6RH1NAvRmG6VaOvy7OtjqaV7IhtQ5i08 7fdL4tPCufna9jh2FoKuDV6WhaXF9O+il1UPIX0VhmcOolJQWDRriP0LQ9abNMy3WYsp u3Ub9LpJjyZZnU0qDGPcXHRJqySoWSs6rjmVd2/0v7EMYvZ81mnrMvLOzGIRXGVRPdug sfGQ== X-Forwarded-Encrypted: i=1; AJvYcCUALRlH1E3Gd5JS4QExBvPI+ShzVBRTv48IuhPh1duetbstw8yalETxA1w/rxzUB088QZ6M9z8145+KCmbT@postgresql.org X-Gm-Message-State: AOJu0Yw3elcUh4w6el2+nNF7vAhSaIVgHloOkkWFhmA614nJOTnD7V/b p8DhqddmKntJwdJBW+9ZaDqagGi4foTY6Oci9l9vUnsN6yztvml5cGIy X-Gm-Gg: ATEYQzyZVEloFYtR1hEFGBEVCxzL9IIbM4JxnWz2V6JCYG10KQ1JHeA8aw7Py5V3bVF qLtiyk0s7WkY/4EYGH8OXHMc0T0PTB3+eQPTd9Z9qgKaCj+YdmCeIkhH9fEK9x6FJyy/hbzwPLu skwSbHvICR3C7h2zgH4yUC7S2QyjGvCL8YkOsO1eftEeJZa+g3slb/JGQBnKnRFtVkxTSZhBaFV UkkZNNKHn1GUEmEz+pQwvUbqvDColHrhleeC+5n1BVW03O29ObRP75eLO7bbdb/eSL0sv4VIDKV HKNE4TRR8pNpRVmjSt0ds7zXaotZUsJH++DR8HYt4tb/a5MIJro7dZtFnqIq/bFzlqku7oOvl8K vM/ZHZRTwELrHoTXugA0qC9Evz2omPA7BhEct2gvg0OOnw3hPmqB7UUX2WJrLvEO0351cTA9AKF ebEvv8XooRp2gcbcj+qPUhME41fnvHyM2xO7U35nb9yNuZiR6tp2ccJRHCjmkdoBIx1Adt2MdtL V90yMfdaBiF2tgiBbFCDA== X-Received: by 2002:a05:6870:e38c:b0:417:3166:edbe with SMTP id 586e51a60fabf-417b91c4948mr2236508fac.16.1773418611387; Fri, 13 Mar 2026 09:16:51 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 586e51a60fabf-4177e26e2c6sm8941501fac.7.2026.03.13.09.16.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 13 Mar 2026 09:16:51 -0700 (PDT) Date: Fri, 13 Mar 2026 11:16:49 -0500 From: Nathan Bossart To: Nazir Bilal Yavuz Cc: Greg Burd , Manni Wood , KAZAR Ayoub , Neil Conway , Andrew Dunstan , Shinya Kato , pgsql-hackers Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD Message-ID: References: <43de48dc-701b-4735-881b-50bca6870f39@app.fastmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 13, 2026 at 07:14:06PM +0300, Nazir Bilal Yavuz wrote: > On Fri, 13 Mar 2026 at 18:29, Greg Burd wrote: >> I also created a few tests (attached) to check boundary conditions, I >> might add some along with the RISC-V work. > > Thank you for the tests! I have checked them and the output is the > same on both v17 and master. Do you think it would make sense to add > them as regression tests? Seems like a good idea. I was curious what the test coverage looked like without extra tests. Once there's a report, we could choose a subset of these to close any gaps. -- nathan