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 1w00ay-001WTL-2t for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Mar 2026 17:10:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w00av-004oY0-2h for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Mar 2026 17:10:10 +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 1w00av-004oXs-1b for pgsql-hackers@lists.postgresql.org; Tue, 10 Mar 2026 17:10:10 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w00au-00000001Tpv-0ulN for pgsql-hackers@postgresql.org; Tue, 10 Mar 2026 17:10:09 +0000 Received: by mail-ot1-x32c.google.com with SMTP id 46e09a7af769-7d73e0e0a36so1190960a34.1 for ; Tue, 10 Mar 2026 10:10:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773162608; x=1773767408; 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=JqOR8LKbN1Re+jRRXNCArDRvj897oNd2TcnAaFghuuo=; b=ilWMFm/IRtzSgD2W7rjyok1zk9KV23O7tzAj/2uSwmAdsMQ9YUX6RWbemQz455xyqz 1Cm2FDMWGQcP8pUrhdH/CaySYLnkBovmTAK0mal9BXWml/QVC2SAw70RmoQqkg3qaCS2 rDY+CRGL8URHInRSN1ya5Yr4yDvYcXz5zL3kB8azGangMyK0WM2K3fwMXldcJ3Jf3Qj2 LZBaM1w4FmX0pP9i9z0niKXHNZeBSIs5Np/j5hY1Ov0UqHEXOOHvBj2UHINrIB58jStF 03FGousiPwM6MFkTNzNde81uz0uQ8Zw98tTBO8DePzDC2sLOLXCeCCvb3YrxohPk8IPV WLog== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773162608; x=1773767408; 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=JqOR8LKbN1Re+jRRXNCArDRvj897oNd2TcnAaFghuuo=; b=vv2MjKxWdPt8ZZpIScY4jwY817MCix8Wye2BttTU9mofUvMc1OuRhVKCwUJVRNVeys Wl+P2YJWrPnSGXklhcvhChxEM6ixGZk93pJNlewattsNJQSQES67DPjuoFIKLheRY8vU qddGUPiypZ0mNisd+fRAL4iCaBponsSItxbVvkOOuTA0avHan8TkaGlVLHgP88WFylVc zib1kXK1sqtWjAk1JeoZKHyURFbhm5u84lMIhEYk3SrZdZ8asvPN3eDMGnwmOZdp9Ke2 SWrvIYQ5x32MBYi78C3nqwuVVGRtKtsViL+Dlld0/86xz7WpXl5oJinwzdbO7U0jkn8u NCWA== X-Forwarded-Encrypted: i=1; AJvYcCW0fsC2pBIN8aqx3s653dvzZEkPuM+87NnWntx6R+g+LnXFwusGGdKZfWWktA/Dtogz55mW601rUx4yqmIH@postgresql.org X-Gm-Message-State: AOJu0YwuF3b180HkK5X8aqPjzzQQz0+EUZp5NcQ24vEnggPGpJuVM46c 3kVUmpDuiwuT/hEgSWosOLW7QK7SvUpcL5REPtagMlwRP+LIPErBU/8l X-Gm-Gg: ATEYQzxrIyZg2s6tgbmEIxjN9Mo2mQCO+uiW+VtjZdrh9OWZNnzL4HfoTteryNaeD/I 20F9oOk3rJicfi++zNSRUbyQg05RjXbfZfqfs6JKvOVHwahwzWZzk/IBTLvjs0Duxbbg2o6ysRH NaBCDqQbpRrDinTXWTiEpnwYwSgTzkYtxFP/5mLzz34lDMZ6ybULzUkrq0S3TR+aofqUuFFdfyp 2V6Sr3r60YQUaGe/VlocQpqUqLEsz+HhntCcNZk31qeBNIH3BEhjc2ly+ERg+2QD9jbREvsiezp C2fbSpF9BFnn8AzU9T4usm+kErGPcMrpos16zbX9vTXcaaCo79jEtmgh5OoEuU59bWtefE45ypn bEXY+d7VbXRbjWwW0a+MYhet/HyrOrratc3Ay7w9w0DdddDJQ3u0wLfr3+mJlYgjKA2HXpto5z9 t/6B/CMGrbbH9BOUMhnB9z6q6JVQh6hm9yS5Qi98rEqF40aIpJThU0omGL8N3iZfib9MTcelWoz M6Vv1cVztKiACghmPaW5A== X-Received: by 2002:a05:6830:2651:b0:7d7:5e74:f4d4 with SMTP id 46e09a7af769-7d75e74f5e8mr1627604a34.14.1773162607716; Tue, 10 Mar 2026 10:10:07 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7d7403a95c6sm6242771a34.6.2026.03.10.10.10.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 10 Mar 2026 10:10:07 -0700 (PDT) Date: Tue, 10 Mar 2026 12:10:05 -0500 From: Nathan Bossart To: Nazir Bilal Yavuz Cc: Manni Wood , KAZAR Ayoub , Neil Conway , Andrew Dunstan , Shinya Kato , PostgreSQL-development Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD Message-ID: References: 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 Tue, Mar 10, 2026 at 03:35:30PM +0300, Nazir Bilal Yavuz wrote: > Subject: [PATCH v12] Speed up COPY FROM text/CSV parsing using SIMD This looks pretty good to me. I'm hoping to take a closer look in the near future, but I think we are approaching something committable. -- nathan