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 1x3xsG-006nHv-1N for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Sep 2026 15:36:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x3xsF-008FkE-0H for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Sep 2026 15:36: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.96) (envelope-from ) id 1x3xsE-008Fk6-2b for pgsql-hackers@lists.postgresql.org; Tue, 08 Sep 2026 15:36:38 +0000 Received: from mail-qv1-xf31.google.com ([2607:f8b0:4864:20::f31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x3xsC-00000003bNN-2ZFd for pgsql-hackers@postgresql.org; Tue, 08 Sep 2026 15:36:38 +0000 Received: by mail-qv1-xf31.google.com with SMTP id 6a1803df08f44-90e7d9c747eso61062276d6.2 for ; Tue, 08 Sep 2026 08:36:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1788881794; x=1789486594; darn=postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=DxxK65wB7pWO49rMpWx8MI9oaOVhimh9wJh4pdeSeQM=; b=AzuU7a+7oaS6TVk7dKWqi/woSLYTK4jKue4xGjTMMedycl8YszqsJc1NOfKdBYDY2J 0lyRORt+D1ZqzssmemWq+DoWQ8jBGq9VB2G9Jo/rfphM7tMf0IoMgxmwpOqcyy367vQq MJQCfqpsKWqKiw2LN6M+PNpKaTPTrEW2lK0dpL652a+WutWwROGABYersx7CwEnGKsR0 LgfXWPFMSEVLuDHuTJUIOi/dqHviiYrr3p68/CoKoNN+hzYOXZnunxnNuhLuwE/sPWhM rmZdI6QatLJAWK7Z9VdXR5GLqd6HjOapTB7A08RpNItkoOzpQy0rmnvhXnsExG12ejBZ F5fg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1788881794; x=1789486594; h=in-reply-to:content-disposition:content-type: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 :content-type; bh=DxxK65wB7pWO49rMpWx8MI9oaOVhimh9wJh4pdeSeQM=; b=kQXedP7yIV2wkKlSAFVhVjuUAiMD81WOZePQabDhrcIDXluy3nGy+332oCWHk8pL9b SS5yE9cPeKD5SM8KF0vUCyKPf4nUAphZ04MQqFgeM4UwkWB4eFuIQUzDC6bxcbCnzMRy h2UVf0SIdR8dGHbSmc8Y/eWwESIC1cFVneRk6qBrWH2wkJvZ25f6SxWL8GBnzl9nIAls UTPwa5jdkCUe1KT1V1lfs0UCxk2bCx04R8khB+3uWyvu0qOO0JhI0b2CBkLspxuQZ1E7 Huray+S1MwG+a3i30ylPpxU0iGIVf5W50E9a8Aznibu+6GtWxU2DgZtYFCDx7wFfKajy vgew== X-Forwarded-Encrypted: i=1; AKwUvBy/tMAVoEbF1OtkCk7YCo5QrP94RKsNnW+dH67Mep1CAFrQBrYXq+gD4T15BvbqnNwRLV9LlL8YKd1RkFMV@postgresql.org X-Gm-Message-State: AFuF++lLq3lF1wXmB3Y7cbTBk23qAZlSJqAyvbKOyyVKTeXGjuWAI3jf AoSmKGjbdIkbrDSVtIQxOQ+MFyO8/KR0hnN4fljG/L7Vd4WcJlQNI1A3S/mwtw== X-Gm-Gg: AYBFou1uxzB9Ltr541u4g3heTZPrz1tfmshHTOb6YkyB/k6xouZ+iQEk3bCMzaM4fnS uiomFC4VYQHM2biDOedqa5wwS9z4/WJGldfq2N6vG1Ki0zmXRD8/lGNPpenG78bb6T57RcFVA53 GgSfAWdhGzmLrY8dZ9RoFJBUKz85/eG5CxVTWNBjLfUFEnmyN0WJC1RFDBEzRWmXUsl/KGwB4vW aSx2Zw3QMF7QZntfxMM4RVISR+TT/+Nv5Vb86bDv0JUkCrto2d10VIxVKYpzWi3AzTQ6t8Bugyj g537z5H6OCGiTTwcNR3r6Fq7ftMqVLxHnZucBMkXOukJuRpnQg1kTu2DkRfECnrSRhoSXp+ESdj EtRXTiH7Yjz+ENfbdV7Xy2e9f3CknntClWdydxxqXND9jafTeGyNnN7LgMxehIxDHMk23C4k2Qk yvnsSx66fvVFK/nY6hYXRx8PjnWUbrJlLitwvnPU6coSwJZF6eZMHG79/XESjVwceIdQO/fqYk+ /J07v08HLww7dJvxwH9nGPDzLzl2Nd4cbvwn7QFZ0+RrpQgIlQU20q+gXrOTMSf3j1wwMjEqKVl Tqfv9mlA0JxaRzc= X-Received: by 2002:a05:6214:20cb:b0:8ef:4ed2:316 with SMTP id 6a1803df08f44-9103eeee200mr361421706d6.1.1788881794301; Tue, 08 Sep 2026 08:36:34 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 6a1803df08f44-91040693f75sm119629516d6.35.2026.09.08.08.36.33 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 08 Sep 2026 08:36:33 -0700 (PDT) Date: Tue, 8 Sep 2026 10:36:32 -0500 From: Nathan Bossart To: Greg Burd Cc: Nazir Bilal Yavuz , KAZAR Ayoub , Neil Conway , Andrew Dunstan , Shinya Kato , pgsql-hackers Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD Message-ID: References: <78e736c8-7f4e-46c2-9fcf-a6839e393d64@app.fastmail.com> <9434f7bb-5865-4828-9f23-1dd30e50aaac@app.fastmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9434f7bb-5865-4828-9f23-1dd30e50aaac@app.fastmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Sep 08, 2026 at 11:08:36AM -0400, Greg Burd wrote: > One thing I'd like to see land with the fix: a test. I'll see if I can > knock one out if you don't first. I'm open to adding a test, but I'm not going to hold up the patch for it. I've been reluctant to add too many tests for corner cases here because I'm concerned about portability and fragility. But I will admit that I haven't tried too hard... -- nathan