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 1vzBRO-000mBP-1q for pgsql-hackers@arkaria.postgresql.org; Sun, 08 Mar 2026 10:32:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vzBQN-00AVry-1N for pgsql-hackers@arkaria.postgresql.org; Sun, 08 Mar 2026 10:31:51 +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 1vzBQN-00AVrl-0H for pgsql-hackers@lists.postgresql.org; Sun, 08 Mar 2026 10:31:51 +0000 Received: from mail-dy1-x1330.google.com ([2607:f8b0:4864:20::1330]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vzBQK-00000001TQZ-2Dw8 for pgsql-hackers@postgresql.org; Sun, 08 Mar 2026 10:31:50 +0000 Received: by mail-dy1-x1330.google.com with SMTP id 5a478bee46e88-2be1d9c356cso4451035eec.0 for ; Sun, 08 Mar 2026 03:31:48 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1772965901; cv=none; d=google.com; s=arc-20240605; b=Nv/uTIkUr+HbpbDzvPMT2eS7YCKgPS46bStdGJz9Tk+ZG4vRhUwPHjGB3kqLPUCIHd qAO4JAk70c0MrrTcZg9FyJF0bFfayPzmJKqFDSK7WrrVxxGzrG0V0+Dzpu9ViSuSUEmq yjgqoe10TUwmtl7o/3U28oGQe43KlKJ7ao0oWC6nfxQCgv9s4pF3XUBODHe87h6rBv4Q oxIBIfG8kIphOJ+da1dZ6IOpzFUp/rtmNhV21/Ju8bpEwhSwgKb2B8TUXlvGxwgpWOe3 ZgWiG55bPbJtKUSV1YhCrGYPNMR+qVpOmzhV0BZHDDBjXZTNOtnau+4LqUtWIeG1Hvz1 TqwQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=WN54Nnz52LKxKLw1Aeh/vRuTAedHnpLnKJtxAxlXsog=; fh=xV7OszMAPi72+IAGvWWlCU/vq0ndy3hjB1EhY/kYWIE=; b=esUhgSUaKxo+HbpS7f5/ydUtD1zrDt/cAPoa4dNDQcrEMPf8bGEfDqMZ/LeFcKrc3Y h77jy6gGuJmH940lX1PldKwKX1CwRutT5VA+dTEpRb1Tzdy3ErhgHVO1K73Pet+U9FVz hjI1tILrOV97TS6fRv1jfnoWBAu8lpU+A3/fBFi9AWdLOEIUM/96fV6ZwRTmbqkd+82v hWO5nRB4LJD0+ljCkMS2Dc18or8AXziGi3lTf0U+bbxHQryFOxCBFmX22a/5k04wjMu+ f1PIpHGt71QehehoEImD7jWJL7UFiDPLMw8zP+TN7JBXHGctAE2lN25enuhWNZui0orW Ie2g==; 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=1772965901; x=1773570701; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=WN54Nnz52LKxKLw1Aeh/vRuTAedHnpLnKJtxAxlXsog=; b=aBl8H9ilpBWM1h+HfU+hb7oU+XD4blo9P8yhLjqllzpoTFPtNdU3wFYxWNDwj54Ugb 7g/7u/kWjKoyV9domlCPfw/8Sq522q/GswgkkF3YQX6np2DKQ59SnLWDWHHqpVZzENpM IuI/9XOyyD0jiq/0GkL2M5UtMyefOmj69xXCgdX6n11D168wJ58FRDX2zHZPdBkOXVH3 tQSuoUEQvEOCMjX82b557REqvmtpFMzINk5IBQxDQZ5xEfGtiXBpRR+tYEtJPJhA6+sv RtFaFucv37zofGkN7Gv97n8Rz1Uus1C9zsz1cnvlNVyIyDOo0cS1Leli1tYflP0NA0Jl ASIg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772965901; x=1773570701; h=content-transfer-encoding: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=WN54Nnz52LKxKLw1Aeh/vRuTAedHnpLnKJtxAxlXsog=; b=I+SXPwHtvooDDUSAjMFVX+dsvXDiLVKi49KeXy/IWOCrV0nGNP2KFbZ4Rm1ZrH88kh WZ1jJnTUE3x8Os1RwKbDx8lbAJFdhRp63Wq1Qb1VGkJGfzN07kmfFO4z5AKHmOlV5wN3 TdGqokMrH+wN2kJPQNXibGGKGJSk7YsLcNUFYX+8X5ca4qNQBqJcu5EMcSdzsEIsBr+G sIpnaM2BekcIHuvM5xVfnXfo63G6E7+99m2cR2MKnjZDcjJHEwLB+UyN9sXrFU+JPzip y4mAcSzipCSz7Jj1ef4DEreX0vEYAN6bPSJ6pecwvuLiCJ+F4xpNkzWkj78kp0czedt2 EiyQ== X-Forwarded-Encrypted: i=1; AJvYcCWOk/6fe8qKAXcTp+UQgSe1U4uDisMGAJc4/T77AdXfUoaQ+XdYdec4XBAwp2PdqOZQhlRMGEtiz/aJub++@postgresql.org X-Gm-Message-State: AOJu0YyuY8lhdt91ZLUBo7a7X5IFMB4Vzu0NU3WEyvpgYa1jtUBcSiW7 JqIKktU3Gkq2mRjrmapj/siaXrdv2BUY40+VHf0NfYFZlb2bG1CWJlmxwoQC4qPZ4SL7ERIYlzS AuzdFLdOjzgxZMXMyHqIdpef8OaK2EqY= X-Gm-Gg: ATEYQzw50BvnSJ/RApDXJl8ovOCv2dAQzL2Xa3FBqptx0hJJ54MuF4losHcQ/7krZzU n/8N088sNSz8u7SWF47cGg2mzmpaLHsntD2I41GMGuD6lcEAk4jWR26ObBrTcP8j8i7iAGgE1/3 53ecPozujoYs1tFyLy85t2mGDspjMeCdEpUfpzuoqZlD9UJmEVrVeu/OCnTXMvrMOnFRHfxO1jw C7DUB2lzwTzoorn12RQqVUKy77MlLkDQb9I/YhcnJz54++m4AwHklK64AGMglyJqu4Ab5GHUnUT geLUqyc= X-Received: by 2002:a05:7301:1e8c:b0:2ba:a712:51e3 with SMTP id 5a478bee46e88-2be4e03b51emr3171501eec.21.1772965901514; Sun, 08 Mar 2026 03:31:41 -0700 (PDT) MIME-Version: 1.0 References: <91acb778-42c4-44ef-8888-f18ad9b12a5b@dunslane.net> In-Reply-To: From: Nazir Bilal Yavuz Date: Sun, 8 Mar 2026 13:31:32 +0300 X-Gm-Features: AaiRm50Hf6rNbru-ANXlwVY4Xs-8SyGAT6Qi4CLt4UN-6p3EJFC8bWHAemw3B2E Message-ID: Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD To: KAZAR Ayoub Cc: Nathan Bossart , Manni Wood , Andrew Dunstan , Neil Conway , Shinya Kato , PostgreSQL-development Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Sat, 7 Mar 2026 at 02:31, KAZAR Ayoub wrote: > > On Sat, Mar 7, 2026 at 12:13=E2=80=AFAM Nathan Bossart wrote: >> >> 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 p= atch >> > 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 wit= h >> lz4" and "v11 with lz4"? Else, we have multiple variables in play. > > Yes I agree because the lz4 effect doesn't prove anything for the SIMD pa= tch itself right ? So basically a comparison for the SIMD effect should be = "master with/out lz4 vs patched with/out lz4, respectively and nothing more= !", is this correct ? Yes, I think 'master with/out lz4 vs patched with/out lz4, respectively' is enough to determine the effect of the SIMD patch. --=20 Regards, Nazir Bilal Yavuz Microsoft