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 1w0JL2-001nhX-0H for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2026 13:11:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0JL0-0096rv-0I for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2026 13:10:58 +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 1w0JKz-0096rn-2Z for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2026 13:10:58 +0000 Received: from mail-dy1-x1335.google.com ([2607:f8b0:4864:20::1335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w0JKy-00000001byN-0uRs for pgsql-hackers@postgresql.org; Wed, 11 Mar 2026 13:10:57 +0000 Received: by mail-dy1-x1335.google.com with SMTP id 5a478bee46e88-2ba895adfeaso12132087eec.0 for ; Wed, 11 Mar 2026 06:10:56 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773234654; cv=none; d=google.com; s=arc-20240605; b=JwbId8sNHt7W5uxpTMTacryE8yWf0u2QeLY2i20g+Fk7NlLn04z9KO0B34MNts6M9j UK++YXlQTtWox42ExIMFwAUJWzvjNv+0QlJm4Bp8z2wxxRhNhgkct/jPIN39S1nW6ZWY wougU+wTA23VYr5lMEPB4Vcjarz1lOkFkI8SA8B7cQlKHXa6Kyl0Jea0QAxZV9J2Vzj6 mh3DZYkClp8xQAVUKgOFh+wnXQP9kPjRfwkpUlOBf/u+gJ/1nmFD8YBF853k/741I+qj cTuNcCkm8eoeVc0LWQG+CgH2lR8Lgnb6mdGh/kBcFlt3W3s32Wmgeb1RPRwBvWo+yxPa YeWg== 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=C1Qwe6pfjlmhKqhoO0QvYvLP9GC+pc94yauBZvE36zE=; fh=L2QyPJ5kwX56Vf9kkZ9D+Bdq0B1MXNN55rcN1Fu7aeA=; b=k9Gv2ZAFr9LAiPgSus6p+QJcM7J8HedNYap5pr3VEiNYJeDU9duseBXWaW6Zgm9Huq WtU671J0TXcb9t9U/7Tchgd0ww0qM4dLRPXc1uHAHFXUVPHzV+KamDMoTNdm2RpS6YUW gy0tBxLjTm1auT4gNXOF45aN0Gdat8gCQ5qRZxWh3WosIjqkaPt3uQQ/QV3vzZM3cxsy DGI10bxxZd8f5sx3M4+HUToGwCYkVscMRENeHzgZZ/HzocMaBtdWtHrDZmvElyfpx54t QOYzEyG7v7qMdURmeQaBgPGumluGytjohLDFX0J8nFFJkXexNYI/03CjM15HHYsGfVk1 yxWg==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773234654; x=1773839454; 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=C1Qwe6pfjlmhKqhoO0QvYvLP9GC+pc94yauBZvE36zE=; b=Uh4xvs9sP02jBPI99SYRgwfkdsp78uRUBycqXq/epfjlV2LINW/oP76K+URCaVHzwx Et8QJ+781in/4n8tVibrF6m65VrPDjcHOs2V7RRG+kSw7+Ag/jooSgy5p15Mc4taH+Pl WJsqJpj9FMoNlu4HpNKtfz1CMwFhqhv0E/adHyJLWMCHylXi+jk7N88qIhqqu8VfByp7 efs+YkftTl0rhmL8R8KlGvT3kMlyir1dIUniA2P8qdhOZIcJSNcnXBBOxUaWZf5Ky7mB O1Q7unr4X3dqpEbQu/4K45EUrClxyBahOm3sgd0+uNJxVBSmSb8mv9yMSO6cBivt88ux rKlA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773234654; x=1773839454; 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=C1Qwe6pfjlmhKqhoO0QvYvLP9GC+pc94yauBZvE36zE=; b=u0ou2nGIBWZeHq865sPDgSEhF/kJi5mbNHP5MFZZ64gyjvkNpitQSvEVBdLrBmBHjX a54X7LuH7PqTIP2/sqbwobyCoIYd1zJI0gRUXXgVvMiXY+CNmhaii0ZZQTwJGbpSm9cA RNeRV6nRpc/hup2L6W3pdsoUM2nOTidDfsrVoRZQOgAiH2K7+jBwtyRQAAMIDEqcmrT0 jRL2VNZ+rEU2p8RTmBkLNGmHb6i2WhUSFSG9Q/i/qATA0GFQbqWcaaDJNtwHYl6r1IRp pCyqPDpMcQFr3Kyb481OzMFK1Qtvg7jOgJKE46yIGVa723ZdU3e7O0l66KdCUnZGRIWC De+w== X-Forwarded-Encrypted: i=1; AJvYcCUIfwHMBm0r6Rnc6IP+TleCesaTyEmXdh6ba6DywvsfuYtkYdNSWTyFEl+EEettndrJ3+vsmGJm28IzTqTB@postgresql.org X-Gm-Message-State: AOJu0YzQoqXzt3mSpBBcMKjHWzxIe44jhxTDFsqnSVN2LQOCMFdvQdYi 6bEhRH0T2d4jPay6YdAssCppkepz3gwzm2oS0NVGkad1r5qnhfjzx4u7OYH0KGOQY4UK52WcyvO FchefZJHcfV15eWwB/M3wy9UZB400b7U= X-Gm-Gg: ATEYQzxK5eQHhFitPJ2JU5dM88rs7YErh6+cNlgeAajdYCN2Kd71AeOaBOvg4EiM4AT Rv0raVnR0bGSa4CVicueS/tXgGYaxTYsiizrdZ9bAAzgwmJgPEA1ZLzs9x9wpzz+ePslcMPdZe8 0veJwHZS5Cfebaa9w4FNJz94WnXUQmsKDgAYy+w8cUZQv2xn2JNfw18k8nAII3pH5dg/hKxerQ/ SV0bt078NXGk/u/EQLYUUtqygtNVFxDqPr/sEImxfc9kwH0Id8yRkmjvfY+T5KPjVjDMfPBmpnu Z9XN5WM= X-Received: by 2002:a05:7300:fd0d:b0:2be:798f:23c2 with SMTP id 5a478bee46e88-2be8a5a92e4mr831154eec.32.1773234653573; Wed, 11 Mar 2026 06:10:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Nazir Bilal Yavuz Date: Wed, 11 Mar 2026 16:10:42 +0300 X-Gm-Features: AaiRm51A-vZjN8eZvu3_OjboQJbrFSzUKwd0BZeYI2CUdo6sxz5WGFXYyO36E04 Message-ID: Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD To: KAZAR Ayoub Cc: Nathan Bossart , Manni Wood , Neil Conway , Andrew Dunstan , Shinya Kato , PostgreSQL-development 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 Wed, 11 Mar 2026 at 15:19, KAZAR Ayoub wrote: > > 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. I agree with you. I saw very small speedups like 1%-2% but I think changes make sense regardless of the performance improvement. > 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. vector8_eq() and vector8_highbit_mask() don't have non-SIMD implementations, so we need to use USE_NO_SIMD. -- Regards, Nazir Bilal Yavuz Microsoft