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 1w0jyN-002AVI-0h for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Mar 2026 17:37:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0jyJ-00GEys-1l for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Mar 2026 17:37:20 +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 1w0jyJ-00GEyk-0U for pgsql-hackers@lists.postgresql.org; Thu, 12 Mar 2026 17:37:19 +0000 Received: from mail-oi1-x234.google.com ([2607:f8b0:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w0jyH-00000001nr9-1usU for pgsql-hackers@postgresql.org; Thu, 12 Mar 2026 17:37:18 +0000 Received: by mail-oi1-x234.google.com with SMTP id 5614622812f47-464ba2bb3aeso798908b6e.1 for ; Thu, 12 Mar 2026 10:37:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773337037; x=1773941837; 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=mRrZGfAROaCMCUPPCxjJ+4ZQ9UBh0QJAge/mDWWz0oM=; b=ODppzFADUrSXvbuQHfVtdsKTrxIRLTgwwDpACwzmUwQmCE1OOuVU4tn7LUpgdoX4FN YiNyIzFEZ2nLo37R90LP6giXGqszY5kIAy4oIzoa40jr97+NrfPO4f/xWU+GYs3ViUyQ paH+BFQRZyaM+kpSwY9AEGcF1r8l7ozX837YfCXKCN3k6Ae5eVj3RdUXi09k4Czr326x 8RKuIm1m0SyInHypzK0zVusG6dtWhqxM++glw4p35vZE+i0gsTcKFkI7XUhhnnV2YeBV uVU3+Iu75w5ODQ0JbNNOjsSB1n7eR7Ae2IbHr2YhhLXkVFJTfk5rlsuUnfy23ASAT7D9 C1Hw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773337037; x=1773941837; 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=mRrZGfAROaCMCUPPCxjJ+4ZQ9UBh0QJAge/mDWWz0oM=; b=vG+fDv3uEc5ziZ9VTtnrZiLKz0hOi/cOwLP/EaRg436qcHG6IhEYZ1ZpltF2B81pTO 1oIq+kgSRszSRCoRODBVxbhovbuy3bfM+L5dfXvxb+m3ZiJLa28zSYsZDWkp4/yXkogZ RdQL6g1xSALg5ol1sHsKd0YNARFIWfKpFuH7ic/q4zn+k1gd1wWFUyc0D+Fyipg3xPVc E3+CrSjFRx0AOlafTzng+izhETLTABwr7NOY+JOVaJe44ZzSyevBFf3jJC1kOVmHHoaY FAU2u7aXN1KmR5//4WJmFO53KlL8KcGqMgPk5/w0irFhYVmiCJY3bBSlrQZDXYeUtk4H OeYQ== X-Forwarded-Encrypted: i=1; AJvYcCWeYuMf7byTcLQZ15mA1u6kaHKZiw5+ZgP6Qol24Ddxo+U2INEGShQi4jbAZXVmhM+WhxWkPB0x4zI4Cd7O@postgresql.org X-Gm-Message-State: AOJu0YxWRK1CDTcrTNiAKo73ZbV3jbuADrUzFE0zaiSsy4lxfd1lQ0xe GV6bEN26Tz4brDCSF4AqVaw3FeYc3ThzicVgSp0pLB+9MpbEBIgun4ji X-Gm-Gg: ATEYQzwDKEaCcKc7FFkdYkq+h7ud0lA8w2KVbJqQ4OFDvFgCOp74zSSlmZ76Y3yAd4o t50X0/nR8oRLtEJPRWZSyJLofqAnOw/Sx2qDvlvFFCtPBA3MKR4jz6WRnn/mlRzs+gR15ThNNmq RkMHOR2BRWXNwxobQkp43nX+ZKOtE2p/5SY2ToJRhI/apl12qsDsyeNiZJToAAfz98o7PkUr659 QfJ4obZKWwkZwBe0LJ7Z6v2KRGiMFCmZ0OOI0p4K3vBATPDAuuTmcS6C3ix+VB13tUeRcaNvdym wtiEgeQ7nFtSu/e1LXX01H5u2UsURck1MX2YZkS6yxkkMZAaHuxo36Yd2U4EXkbSQHmsztT1LLH 4lqkF9xikidJ36vdYTMBFsK+qzDjtYTZ1/zPtbndH8KAzmxxeaYeasHxR9NHE3X5P7qa3+KcJdk +nxUwnj14yRubEINCV+j1fMWUximBPR6edmKbdtESVFh/HFskcMg3wGsjTECK/a9EYHBeghhad8 Z7j5iGQoXtoniZTes2i8Q== X-Received: by 2002:a05:6808:4f5e:b0:467:6b8:ddbb with SMTP id 5614622812f47-46743206a0emr2341704b6e.17.1773337036695; Thu, 12 Mar 2026 10:37:16 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 586e51a60fabf-4177e1fb6efsm6216213fac.3.2026.03.12.10.37.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Mar 2026 10:37:16 -0700 (PDT) Date: Thu, 12 Mar 2026 12:37:14 -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: multipart/mixed; boundary="H7H3VmUFWwl1uh5r" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --H7H3VmUFWwl1uh5r Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Here is what I have staged for commit, which I'm planning to do tomorrow. Please review and/or test if you are able. -- nathan --H7H3VmUFWwl1uh5r Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v15-0001-Optimize-COPY-FROM-FORMAT-text-csv-using-SIMD.patch