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 1w0IXL-001muZ-1N for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2026 12:19:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0IXJ-008tKC-1t for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2026 12:19:38 +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 1w0IXJ-008tK3-0s for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2026 12:19:37 +0000 Received: from mail-ej1-x62d.google.com ([2a00:1450:4864:20::62d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w0IXH-00000001be7-2KY4 for pgsql-hackers@postgresql.org; Wed, 11 Mar 2026 12:19:36 +0000 Received: by mail-ej1-x62d.google.com with SMTP id a640c23a62f3a-b7cf4a975d2so1700605466b.2 for ; Wed, 11 Mar 2026 05:19:35 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773231574; cv=none; d=google.com; s=arc-20240605; b=UhKBmni0nmLCg/KQ5CyvjX5uWTV342LpuxqD9HnjkYRXqSupWQ1Mkdvl6ZzTUrYbv/ prhhOSlxHgTIZoaG+/AjOgGryC7wg/QwII3q0XAn4ernGSfhLWKDU3xAOXFVKRApAFI4 ghBdNEzy/WKtzn5Dqv9hjRa/U7wc3Ju6cHoe6fiSTX6+wdiM4Pnmy/CD3Nl2UI5Q8Ufg 2J5wQbwXPfpWYVb2PLxhpRbv6T5RorPMrfI6oSD1Wz5qSdviNovd39A1w5CUgvs5fPX7 dNv36PG48OhkwN4CBuFNIzli1JyoVLkWmJb0eOE1pNeAJF23PTPezoAUwyyxf7FIY3lW jG1Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=ZQot0Awq29CgVUIzVueHGWQMf3OoKHcZ0UEN7DRFeEg=; fh=/yqQwIdgm8F5niBreOXt5jvO4+p0u1IJ7cbOscmMGhM=; b=UH+bPr0Ivw5wC96F/gtcaUOgyYu3GnlZlJ6KSWil3Q1oCE2wAUbWfhbS2y2TRlWSnZ Af/a5j6D2wc4CrpejxQP4z2Y82e0V1c0Ul65giPDiOV27QB01GROyjxFitPEK3KqUK0Z tPKwEMkSOlOre9UzfC0fsHux5AgJVdB7UsLZ4a0jbC208KD5yCZtiWXesKJBeRgl98kx CHjzVFTnqgNExzejTboJ3bLAx6cqi7xWd5SOG9n2xZZ6yPEDWsaFfhEVJyyQ10LL0b4M yjMUSM8SJMEeks2mfzjndtnRSVB6ZeGb/waYdMNHLrYG4m5h6IzNGdMhpiobqfS6gLdN QSbQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=esi.dz; s=google; t=1773231574; x=1773836374; 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=ZQot0Awq29CgVUIzVueHGWQMf3OoKHcZ0UEN7DRFeEg=; b=T0/pHcVNGJq1hX1hiIfKOsKxT9PahvhM6UjmMXOCNdWt686i67vfPQwvo3Mw2sOAfm VsV6T9Qo8BeWGI4PR8GlUeXqPo/mz9vn0FO63W182O9cKgAgthU43Huvm3JaBd8Dw4Eo nyqBOoIB4r9qMTMhQoySuXeFURN2nYjh2YqAi/28db0Ylue9sbr6mITenAXUeSoWc2Fa 3qnhHB23GTPno25BQNABrLc+7SzI362LLzq2txhGhDj5is267jwQe0x8kLnTbxAvyt3b jpSbuRH3oL/AR6uG1mpGiFJ9oxmDnQkqz8ODzRLAqbvQ1lykwlDhwxyFIFp54qklz2KR pHpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773231574; x=1773836374; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=ZQot0Awq29CgVUIzVueHGWQMf3OoKHcZ0UEN7DRFeEg=; b=PTgNxLVFWWB6FiAfEu5QXXq/j2Q8onSOznTAPAIlPca9dicjUpbwO+2qEBonJJ2fDV /Pyre84ilPFmWHBW3KGyAZYptY6G3xTjyEiW5MMMmT+0/FJ3pnPizTKLPhMkHKyRDQXf /nNtA8KLrZ7/VENUAMb+NGDW0Ba/0ELAXm9/AlMg6aWSZilHRppwyGj7rkztt6w+jspm LTE7KM0wd2VvrEZ4AT23ly/4/LpMEcMXyeIsCHpve3ABuzwtkykMLLF5N9W0WNmdOlEQ OzBde6oX4CBTm8FNKI3r4Hk+3/GF7pyEXexxi6SUkpFMZ+zg2tBgB3alcz84q9XwTdZe ePvQ== X-Forwarded-Encrypted: i=1; AJvYcCXbCZEM1o9l1cL1UYa/jamgSpGGg3baT2JieCCyDeILmp6k0gCV7lZz3tTxMfIY2L0MWryMn3fT39TfC4fJ@postgresql.org X-Gm-Message-State: AOJu0Yxve3M7TfTCpDQtK6WPVTQsCqPgwWhwXS0UO1yvQgJ2nfAXLoFy u9/iOpmakyoaurOY5rUr9F0ivRlCgvLTPZJqIvE9q+B+onx5zUXlAHuIZNuGSJB8HZAx+oU2K55 iAG3Fjeh9aXtA47758hPM6GVZ6ctOi9NY8VAiAgo9P892TLQMjRA= X-Gm-Gg: ATEYQzw1hRkQYnsxYF/L2qJnMspXHVbfD0098GLUl+9S4S3T9pfV1nVZrVrPbzHflTq O3f068tgFXh9zRFwe5QkGEz2X6ql6yE+rVgvgxqSowrX53nwt6wl+4UoJEGBAQ/X2EIoGT7yuR1 n/NMzKPYkFG/gTH80F8zrKiyJnbNYeqoVBjoXgqq2rxHWEUg7egsS+iIA3w8YdQ6VOH2j1FjJ/X R88kSzqxky60dFhoCkC8CIt7Mnx0Lq6vmDhkN755X0ogtLtbJngRAvS0bLyvuckqVHKbQ8PDYLV YXERVZLIdHTTxqxTzn80tzurFUfn58F5Tbx/rGSjbU4jB0Zy3N8UpdmCybELT3SMMtAhsQ== X-Received: by 2002:a17:906:9f88:b0:b97:f43:2a83 with SMTP id a640c23a62f3a-b972e5dceccmr136080066b.61.1773231573487; Wed, 11 Mar 2026 05:19:33 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: KAZAR Ayoub Date: Wed, 11 Mar 2026 13:19:18 +0100 X-Gm-Features: AaiRm52VMUA34gdgR0C416Ll_nAYunRaW4ovgqxmKhV22RJvYqhOUR9JerAmpTc Message-ID: Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD To: Nazir Bilal Yavuz Cc: Nathan Bossart , Manni Wood , Neil Conway , Andrew Dunstan , Shinya Kato , PostgreSQL-development Content-Type: multipart/alternative; boundary="0000000000000ae05d064cbea6c4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000ae05d064cbea6c4 Content-Type: text/plain; charset="UTF-8" On Wed, Mar 11, 2026, 12:36 PM 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. > 0002 sounds really good to have, haven't measured the diff but it's very logical. Another quick question though, do we need USE_NO_SIMD for any reason? I just remembered that there's some simd paths like json that don't use it. Regards, Ayoub > --0000000000000ae05d064cbea6c4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Mar 11, 2026, 12:36 PM Nazir Bil= al Yavuz <byavuz81@gmail.com&g= t; 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.
0002 sounds really good to have, haven't= measured the diff but it's very logical.

Another quick question though, do we need USE_NO_SIMD= for any reason? I just remembered that there's some simd paths like js= on that don't use it.

Regards,
Ayoub
--0000000000000ae05d064cbea6c4--