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 1vyeMB-000IVS-1m for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Mar 2026 23:13:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyeMA-007JRs-03 for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Mar 2026 23:13:18 +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 1vyeM9-007JRk-2N for pgsql-hackers@lists.postgresql.org; Fri, 06 Mar 2026 23:13:18 +0000 Received: from mail-ot1-x335.google.com ([2607:f8b0:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vyeM8-00000000sZe-20ew for pgsql-hackers@postgresql.org; Fri, 06 Mar 2026 23:13:17 +0000 Received: by mail-ot1-x335.google.com with SMTP id 46e09a7af769-7d738fe814cso42012a34.3 for ; Fri, 06 Mar 2026 15:13:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772838796; x=1773443596; 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=okAk53/CE8B1O6TLWhIe5H5ztaU0eKWd0W2rSqQ4VZE=; b=hkzFxehtWy8PnoC/C9E+vVEEUCSBUYn5OukVYmaj4ewYMFB9TGzdNQ4yMSyjnGUjHc QsPTA8JAwJ7tZTycblPYgy8/2xtAl9yTHMpkqAtLYYmftN5xGmUZZsPprZyUD1qiP/Ff XBBJiMwkHwDYFMT1hrqCSDMfT81JAB59h1mAzAmASkyJxygOy1LnWIMBpRPd3JOdCb8Q Qmv5ojJg5r9OJMEUInscuBgkAqK2dS/nVPN+cDlE/xC7jRHldsFMnBfrk1oz7/EcYfLk J8/zPxfjqFu4YPxy5VhxMxZUMxlek5R+DtcXYI8hSGtouJJoWb3WoOCDxwtbLx3NzVMx hXFg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772838796; x=1773443596; 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=okAk53/CE8B1O6TLWhIe5H5ztaU0eKWd0W2rSqQ4VZE=; b=gKkdM17wZ7X0I+97OYwdV0tNdk4md7Zf0wQbvrxS36dAph5SKZG26/VeHpFUbOZPDr fqTcupSohcshu+Rwbi4bTd6gHI0eQnVcrd4rkvt60OO/Zl0Yjcgu2VvWEVkbpnj9Xybn a3ebJYbvhZ7wTk6Mg6p9pRZxJcx5vHy9Zphteuyldai3EAKxxw3omdbGD+2Rms/A5UXh MzYIO6mjzfAoYQNjwuDvRArpKuOrRXxq4YENWI/7dGCUXM/rE7kbPtN3Seog58gF0oNI 7qxKbXhy5z7I6MsJZvmXYjWNcpYRMJWhNxY1zR039cghvvRE0KgOCd9lLqWKsb4zyqK6 9GPg== X-Forwarded-Encrypted: i=1; AJvYcCX52zwijQNbfx6KYgvhMBr3+e1eUG+OdAPZ9Jkz7jAhl9ri/gZ4/LPKWriJybfD3VUbMt13zl9SE0ydRXGq@postgresql.org X-Gm-Message-State: AOJu0YxWjSbpTHTz+edFNqSDyTNI2S2mDyMNPIS5t2Gq61WMN5KidIzR YFm0LrusP0MKLS2cIJUhWUK+78vVlu7oQgbnK5fgMwiE8LmVSTK89S4o X-Gm-Gg: ATEYQzwYZrF6hqJnNUVn6rUW6uQkcK22YIU6zJBmefSsDEDOIlREhkQlSX1XZHEKUYf KHL6oBUmWfMGY0t2Z/HM2dW+tRbqnU3wi8vVe6C0Tb8upm5cSoxKa4LMajlUaLnpmyULP6LMk2Q 8Cfh9GXuZRnxjBr7ujzW+U2JWnqvVFwAPbOrgSXNQECMJ+Jz/rQXBqJtkcW5IyXUDEIi1SVT4w4 zY+jp/dUHrTnpD090wDbQQ7UL8/N5pYe3uS+1dBXLNsnF6iCYSUT12vE5cQJpjUPC3by/3Rq00R Y00xNKCBp+BupoJmxhMzEWyOo1B1KmwdZg1/jqTcoMS3dT3+dnQu57l0CGgKM90cao/VfxjBNhz GNifrxoyDWj/0hEBzg59w64uEjJJHNZrl+fwGs8gKB7rCcX72RI+BdglrLZ5+kTK7oKUMbLnVPX bs+4bBhsL6D2vAWMiC8woO2dX5x+CigKumwvEiFSr9lIEMMk1QrBT6CUl3JBWpx+auY22TqsmsB sx7/hRUJrqY+XyH4WlmrQ== X-Received: by 2002:a05:6830:630d:b0:7cf:d1eb:f37a with SMTP id 46e09a7af769-7d726f833a5mr2756379a34.18.1772838795801; Fri, 06 Mar 2026 15:13:15 -0800 (PST) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7d728d42a78sm1956651a34.27.2026.03.06.15.13.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 06 Mar 2026 15:13:14 -0800 (PST) Date: Fri, 6 Mar 2026 17:13:13 -0600 From: Nathan Bossart To: Manni Wood Cc: Nazir Bilal Yavuz , Andrew Dunstan , KAZAR Ayoub , Neil Conway , Shinya Kato , PostgreSQL-development Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD Message-ID: References: <91acb778-42c4-44ef-8888-f18ad9b12a5b@dunslane.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 06, 2026 at 03:25:46PM -0600, Manni Wood wrote: > Well, golly! Look at these numbers. Old master with no lz4, your v11 patch > with no lz4, and then your v11 patch with lz4 compiled in. I'm appreciative of all the benchmarking that you and others are doing, but wouldn't we be more interested in the difference between "old master with lz4" and "v11 with lz4"? Else, we have multiple variables in play. -- nathan