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 1w16Dw-002YhL-2U for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 17:22:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w16Dv-005Xyy-0a for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 17:22:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w16Du-005Xyq-2w for pgsql-hackers@lists.postgresql.org; Fri, 13 Mar 2026 17:22:55 +0000 Received: from fout-a2-smtp.messagingengine.com ([103.168.172.145]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w16Ds-000000000EY-1JMr for pgsql-hackers@postgresql.org; Fri, 13 Mar 2026 17:22:55 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.phl.internal (Postfix) with ESMTP id 328D4EC00D9; Fri, 13 Mar 2026 13:22:46 -0400 (EDT) Received: from phl-imap-14 ([10.202.2.87]) by phl-compute-02.internal (MEProxy); Fri, 13 Mar 2026 13:22:46 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=burd.me; h=cc:cc :content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1773422566; x=1773508966; bh=cr9C0Pp4fiCv7Ve8olrGYSUJn6BgUxibshcNM0PDtqU=; b= UKz5w8/brrveoG0YLSbtQarIH1cGCjtAKViYJViryFN992jfBeJ7r+w2ZrwW+oqb JTVnbYOEUyT4SsxQbPK8flIiLvKMCbK4znfO/VaHyvgJCx4VzMzqWvGaVJf8/moX flayDOjCI+OpmSiUj3QSulkU2MYHxxFTokG3OpGRIN1G27CkwEomYaRo4Z/nTtZS lrzUi/0VumWKFVOzJe3GaGpFn1+ctkPTbbDkMy02JsuuVOa8wvDUDeud4RbZYvEP h+brr3CYFVFpoA7DMC1R+KZCNOvom6YUNgOR+6IV3GcUAcfhIEoWh+n/Ws05R+Ev kyzI9Q0J54JbuVfrQP8PdA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1773422566; x= 1773508966; bh=cr9C0Pp4fiCv7Ve8olrGYSUJn6BgUxibshcNM0PDtqU=; b=B dCIJTvaAy+lGX+HSprBvBDXpTEjp1xdzGjmgWjNLxCpPKu/LFjhnLpI5u/wL0T25 Z9N+3XqTCkXZEPP7CxCLiDJFliT0wIegw1Gg8O09xAISCWksEcBBDBCocVl5uq1u pkzQ0J5Ig2aRaGCpR/nTm/mcbNWULyR37uS/r/SJo+SkyXlq1jHmegRe8MBwfGSB 93fZZhe0tQy8E+2cYJLiyDNDiNTSwz697VOWJaUe82O1vfFw+p1y1+1z/tnIiI8p i716XtoOnetRlHsaLt7pmnRpvomTRxe5H+uSBqICk4yzqg6o5Lt7Oc56iHfV8vUF IF2tbI4WfXVMzCMUDygBQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvledtvdehucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepofggfffhvfevkfgjfhfutgfgsehtjeertdertddtnecuhfhrohhmpedfifhrvghg uceuuhhrugdfuceoghhrvghgsegsuhhrugdrmhgvqeenucggtffrrghtthgvrhhnpedvue fhffdtvdevueffteehheefleevtedvfedtueefffeijeefudelveeftdffudenucevlhhu shhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehgrhgvghessghurh gurdhmvgdpnhgspghrtghpthhtohepkedpmhhouggvpehsmhhtphhouhhtpdhrtghpthht oheprghnughrvgifseguuhhnshhlrghnvgdrnhgvthdprhgtphhtthhopehmrghnnhhird ifohhougesvghnthgvrhhprhhishgvuggsrdgtohhmpdhrtghpthhtohepmhgrpghkrgii rghrsegvshhirdguiidprhgtphhtthhopegshigrvhhuiiekudesghhmrghilhdrtghomh dprhgtphhtthhopehnrghthhgrnhgusghoshhsrghrthesghhmrghilhdrtghomhdprhgt phhtthhopehnvghilhdrtghonhifrgihsehgmhgrihhlrdgtohhmpdhrtghpthhtohepsh hhihhnhigruddurdhkrghtohesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhl qdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i675e48f3:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id C1965C4006E; Fri, 13 Mar 2026 13:22:45 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: AQjVtvS5d0yk Date: Fri, 13 Mar 2026 13:22:25 -0400 From: "Greg Burd" To: "Nathan Bossart" , "Nazir Bilal Yavuz" Cc: "Manni Wood" , "KAZAR Ayoub" , "Neil Conway" , "Andrew Dunstan" , "Shinya Kato" , pgsql-hackers Message-Id: In-Reply-To: References: <43de48dc-701b-4735-881b-50bca6870f39@app.fastmail.com> Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD Content-Type: text/plain Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 13, 2026, at 12:16 PM, Nathan Bossart wrote: > 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. +1, you said it better than I did! :) > -- > nathan best. -greg