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.94.2) (envelope-from ) id 1vAD7X-00Fgk9-Af for pgsql-hackers@arkaria.postgresql.org; Sat, 18 Oct 2025 20:01:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vAD7U-008s1s-1E for pgsql-hackers@arkaria.postgresql.org; Sat, 18 Oct 2025 20:01:39 +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.94.2) (envelope-from ) id 1vAD7T-008s1k-Ln for pgsql-hackers@lists.postgresql.org; Sat, 18 Oct 2025 20:01:38 +0000 Received: from mail-pl1-x629.google.com ([2607:f8b0:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vAD7Q-002wYm-1r for pgsql-hackers@postgresql.org; Sat, 18 Oct 2025 20:01:38 +0000 Received: by mail-pl1-x629.google.com with SMTP id d9443c01a7336-27d4d6b7ab5so41204875ad.2 for ; Sat, 18 Oct 2025 13:01:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760817693; x=1761422493; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=IkoZ6ysG1c05BQ5d/awuLfpz/wyMwuCiKYFwIcGKybU=; b=dN+uAP985Ri9lcAFVqM6xdUQT6FXnkSsbWiJH7OgBEuBaeBSVqJU+/gOGjETypqIay fOoDMBbJgvQqzuw1BGLQa4gYtg1CaowCy/gzdvvTs1yvCYfrXh4yS6+leXuoV9nybEd+ zI9nfNM4TH+Hwk7NvaL47PHJJRUMd5oBf24LsxNwknFgG0A2X0uy0K01tYExOG4pe4Yg F4IXy6MLXnmBk79cAgZCz6FVtra80SCR2/ULojIjH0/6FOk4Supn2sutON/XE52JXZ78 cuTYkXSaJqrj5aau2wpd6cDdp6dgohsDnOtgG/zrGUtvq5ThfmTxA3WfekrOT45iIqHp elxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760817693; x=1761422493; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=IkoZ6ysG1c05BQ5d/awuLfpz/wyMwuCiKYFwIcGKybU=; b=f7YZ1bAWKILiKUjbS+jyCnXoZaRq1yjTMH35ihAAVeu09z5ImGI1ahkcSX5/JAQC+Q Rj735WzhbO2ozM/Jvdk1GWG1x9h4opSgBUCczJTpyhofWWL1W3UO0PROmQVe+NjNeo2W CADsAV/IvdRgu+GnRVvFoIH6aRlu1+7IORHGEq/xTa3Ti2rglrotcYBAl+CoPf/+L4cy OOvjVqHJ/V0ApHSAjQ4+CilsgN5EcJa7luEsAfk65RNvoPISccGyi3buvlT/lmq+Ivcf IuBx0K+zCe+DC32a+A2eiHCIpGbZHU5JB7lS6unf7/sRLBTThzlInw2q+7Pbyb2z2F+q APWw== X-Forwarded-Encrypted: i=1; AJvYcCV58yHxnJlO+WUm0dhosHUkv7JIkfmg6zMwN6pucBNivOqy+9viOvgb8QG0IMKLRRmgxRDhOdnDOKu3VRZW@postgresql.org X-Gm-Message-State: AOJu0YxBrNi/IVe2ZaOnSRCYL3Jx8W6AJo95RFjQESEdvbuDl6nUdzaL kdFFaQqUmbn3r31fmLK+I1UbbWA7mVxmys9zFNaXirx/CtgvMLqpfnoJofqHSVM0mA7F5n9te/A YmN6I2BaqnoImSm3PU6W7Q2SSK58pStE= X-Gm-Gg: ASbGncu1vV+dhoe+LvDILyaFxcbyZWZfUtML5i+HvUcbP19Q6zpxDZcdKYET9QPxi7G sqISVu1LAhnNHsTxvjkcQaoGM7mBd9vWvniJ2PjLpNkiv+9Z5rpXXRhcOuEdbjHEyE0KS9ky9HO 0+jPm6fvEHHRvM3lKKUR1Y1/W4Ocm39bIaSPnGCwlsprR5l2FPld8ZunccLDpX8s/H2eovqglKR 9v3lzNMPsi+S9Y9LJWYiHIPE1vV9HGhvLrKcyV007eKnhugZIDs/ubLma4C8rsJRjIH2Q== X-Google-Smtp-Source: AGHT+IHh8eiqYPsOTMWYAHQBQU2Wa46rjdE7zVsH4EWEuCFKEdahkokvOn2B98ScU4QwpPtuYcxYE5Vwg0K5Ei/AKpc= X-Received: by 2002:a17:903:240a:b0:25e:37ed:d15d with SMTP id d9443c01a7336-290c99b11femr98308255ad.0.1760817693563; Sat, 18 Oct 2025 13:01:33 -0700 (PDT) MIME-Version: 1.0 References: <8615c983-1662-43b4-b0c9-49d194ac33aa@dunslane.net> In-Reply-To: From: Nazir Bilal Yavuz Date: Sat, 18 Oct 2025 23:01:29 +0300 X-Gm-Features: AS18NWB3Q41YcsQVdQgCGQ6VCyjvpdLjV07o5WYuLT6Vo_soxrR2lFkp6prjMao Message-ID: Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD To: Andrew Dunstan Cc: KAZAR Ayoub , Shinya Kato , pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Thu, 16 Oct 2025 at 17:29, Nazir Bilal Yavuz wrote: > > Overall logic is that we will not run SIMD for the entire line and we > decide if it is worth it to run SIMD for the next lines. I had a typo there, correct sentence is that: "Overall logic is that we *will* run SIMD for the entire line and we decide if it is worth it to run SIMD for the next lines." -- Regards, Nazir Bilal Yavuz Microsoft