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 1w0Nzr-001rW8-1v for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2026 18:09:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0Nzq-00B17o-01 for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2026 18:09:26 +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 1w0Nzp-00B17f-2L for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2026 18:09:26 +0000 Received: from mail-oo1-xc31.google.com ([2607:f8b0:4864:20::c31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w0Nzo-00000001eF9-2J5b for pgsql-hackers@postgresql.org; Wed, 11 Mar 2026 18:09:25 +0000 Received: by mail-oo1-xc31.google.com with SMTP id 006d021491bc7-662efd1bdd4so151201eaf.0 for ; Wed, 11 Mar 2026 11:09:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773252564; x=1773857364; 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=V3s7kAbgGxOxZ3oH9LyxR0cmPHzEchAUWfhBMUHlhHs=; b=WmAdtVRLhjzDGJ/kUllBWGKy6VAkHLL6V/KCiXCoumTIU0NuYS6WgEmpTuZAPq/xUH Up1M4wihtt9bwHmfLhEXDw02kPOc4rw4NSNlLNMUXAya/kvwZIVNzHPc0VRw5+5Px/gW 4cq87WdofwcTy//7svfC0rqE68SJ9jZfz0iaTQLc238k+gdWTAswI/BMiybhCBo0FSc2 sSdp27nqzhW9l3wcZgotkZPFRjl10ddZyODpxJDcs2tarjj/sMLxnZYkirOlZE4Wwx3A zhn+SnE+CMA4xfWeBjofS0Ek6HZCVKHXO20nCqIDA/S7/nEk4tzfExfE8aWhLcxnk5iU AUEQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773252564; x=1773857364; 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=V3s7kAbgGxOxZ3oH9LyxR0cmPHzEchAUWfhBMUHlhHs=; b=SIKjEjb/r6jILpdPP9xCiVG+9BDpNbl0wuODbsAbhmt43hKTCQyX38BpxYbSr+ofeZ /tXwZE36gzmWwVGzrGXMURest7UsMYFRsybhvP1Pn4Q5HGFBl7Vv25y59QQy8OIl6axE gQLRwL6fxnGai4QypFVrMS/JplsZb49JEJDfH4lmM37x9Sw3Gb1vKxwS0RLTw+67Y97O Xefv7pvN121PXHdqCoJFJiu2tHW77sJ/+qS0VMDywhXj5x+5cvddF1YjX98mf7BxP4hg HC/fJ5FtFsdAiDGp9y+EpyziOimZcJCEaFuJb6a3TJUxF97M739VUoYoydj9PvO6wxsf XOCw== X-Forwarded-Encrypted: i=1; AJvYcCWN6UK/8Tj/M0N1ES9sHdrRD007uwmo7g1FfYSmSjJg4wM3g96EACuYuEx81ZbKeGmm8zV2iPhIEGfU+cjQ@postgresql.org X-Gm-Message-State: AOJu0YxJ0gnf6XehC82PUqW05nED3aCuE3Jv65mTpV0AGMF7LHX/g8ZU 1+dikd2kx1R+7+wKJ2BBxSY1iWhmXqaNs6q9FgkOxb90pjUISG9TtvFM X-Gm-Gg: ATEYQzxafrnaHcXTSq3at+ZdwZeBWMnRVo4HIASX34zbRPPpuKK75nMdro4TLYkLNx5 aJMmRhWskHqwkw16zmaclQil+dSwdYtKyeghf0hubDsVUZptMXH2Qzb6Tp/XyOXAZqDHJ1p5LD6 wHVz3dHOmrzX7KcRNizASkDF7+zLUQVEHDMUbC6YQGwApAKPH4CwZ5ls+yKuFX6DV4Y8mRZETKQ MYCxldFGztwS5qYQ1y35ig+KV3w1XaxSizHouHmGHJ/qBVOI0w4gBCXyNti3tJNIUevPhbgvq6Z uCQ/lLoDjZ7Zl4bb7grCciNSr4ji2gx2gam1kVpGPCdp4n5Gr4ttiSW2l85uk3+Om82W0FIPiaS PhIqmnXXUAZ22HD9gJmUVeLCJAzyJwvYMVI7p9WZgruqZcYHrOIDbMXWvPJQnZObcirKLHQY76Q +k0YSl7xiHZu/vWwEsN10gd1coXtPTFOnvmUPsvGNaLbM8CgMTouJezPyJqHXi+Wgsh4HMbfb9r ASpXhzPyy13LR9ffNkiVA== X-Received: by 2002:a05:6820:2187:b0:67b:ae3a:33f4 with SMTP id 006d021491bc7-67bd077d8dfmr258844eaf.33.1773252564014; Wed, 11 Mar 2026 11:09:24 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 006d021491bc7-67bc93279c6sm1699843eaf.12.2026.03.11.11.09.23 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 Mar 2026 11:09:23 -0700 (PDT) Date: Wed, 11 Mar 2026 13:09:21 -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 Wed, Mar 11, 2026 at 02:36:46PM +0300, Nazir Bilal Yavuz wrote: > 0002 has an attempt to remove some branches from SIMD code but since > it is kind of functional change, I wanted to attach that as another > patch. I think we can apply some parts of this, if not all. Could you describe what this is doing and what the performance impact is? -- nathan