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 1vtN9w-002NiU-23 for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Feb 2026 09:50:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vtN9v-007L90-11 for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Feb 2026 09:50: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 1vtN9v-007L8r-04 for pgsql-hackers@lists.postgresql.org; Fri, 20 Feb 2026 09:50:51 +0000 Received: from mail-dy1-x132a.google.com ([2607:f8b0:4864:20::132a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vtN9s-00000000MRj-0z0T for pgsql-hackers@postgresql.org; Fri, 20 Feb 2026 09:50:50 +0000 Received: by mail-dy1-x132a.google.com with SMTP id 5a478bee46e88-2ba895adfeaso1848181eec.0 for ; Fri, 20 Feb 2026 01:50:48 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771581047; cv=none; d=google.com; s=arc-20240605; b=O6MgHZZJWS9Fpe3HyFMSImgh2GyKeLIfbpxtxoRCmGC5wz+tN9AtpnVqEH6EoXJBZj yKI1Msv43Rh/A/JNp7NYYvuDgCP1/46FhPwsEOmdc4RPPi9OhQQMZ1OBzKOZpWD+pYEX M0eWfH+AT+vgdId5oDFjzNz4azeqr8jpOkKnDXeCpAEBu/dvx/tIIfhE8dvI90oQOkiD aBOxVFamYKkNuveDPPCdMQXErAX0GfT5E6FmHWM3RzLXVp4OjVzJF3RKfWyaS0UfqtFb DxpSp8tjAfmFwbftk0R24RRwegREW0Yv9Fet5PM/WAP2Pc2wlRGf3aCakwa8/Bcj8I2U 8Kfw== 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=riYT20EEWfU6sqYNjR6803pMWMeHoMqddJL62kpzMc8=; fh=Lo1tlH/Wp9uOWlvj/DdfQPGcOY8g443kHKjifdNUdi4=; b=DQKFFkztpHmGjAPgHmLz3D8tf/UaGcGles3T//+thG/0Kuw6XLbpqiGLQBrGGk9Neh xG+j9CeAYtC+vpIA35TaRpFO0ahsLNQ6HP5qECR0ckKaacy5mAGfIbBUOaev/qx8uvxb 0Cd3m/0iOSyvAFbMon+LK1idSn6qZYKU4TA78Wl07CNs4rORxsh7bKpKXsVpvlY9y4JK Wl5YWzyyNYhCtqGJ6Os1sVRiGbd4M4D7QJihqxG60svFw2BvQg761DZvIQZ7zyXydyV/ SvINwuwBv035UOjKGGVPUMqUEOlcUpT3BkLWfwd3UwiA9KaadJGTO0ckUHrBrmFxRiEL 5jSQ==; 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=1771581047; x=1772185847; 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=riYT20EEWfU6sqYNjR6803pMWMeHoMqddJL62kpzMc8=; b=nT/a3CBfxRRTdjaFnqat5NVuC1w0MVkXlSFIFirMMu10WztVIF2qdkNeoJXa1VeXyY i7xlyH9Yzn/51k7gaONfQKgWFLwgohQeLtE6ASyaKXUoX64VgELEiPBGgTL3aWCm9b3P 2SFdAe9lwh17Meg6Zl9aaxyId+zSpuVV7Qn6sNdcKmMu3VcFSMx7DBnTk/Dd8qJaYdF6 yO85aFqM0+WqVIsr8O2QjYenWWYKu9HxRWxWmPY4lpaPu9GH9ODTxVMHTM1pLrNTg2hs GqxyZa/jng7EqMJDjb4WCoHsyu4H6HMlSzL6v2iWbicDTctQ7m6j8yZNBnOJC/mT8HLQ 14Lw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771581047; x=1772185847; 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=riYT20EEWfU6sqYNjR6803pMWMeHoMqddJL62kpzMc8=; b=ZA3kOsMkriCmrFJBZJC2voE0nizH5u36iTbhqLBh7goh/TVMTe0hfi7O1DuReaQZvN xEBy8x4fOgYZ79aPMOIicQ83hGZRNANC8VxHBPoittEyayd+LCfx4VcG2KZfB8BbOVwM 9YmfzOsoVtj4gAs4hUp42LCNn7YZPsfq4N2h0P2CzvWiV7ZoTp37E5mI4M9kV9VLAKRq cuRpD57BD7sBkdelzi8iKwlVSXc11TkTfpzBaPnozCTtbT3n6fxCOtnDRoZi8fMebZqO sI1hoFKOWKYB3gf6wPAW1gmkPDql4dRdKXMGHCTTqbH5NA8aFHvJ/cOYe7z2wyQMlXcH epuA== X-Forwarded-Encrypted: i=1; AJvYcCXhb+R2FcSFPnhcDXmE5f9VDsc+gicCL1QuLktdeven/kWtqrFmrf4TK9DidvOHCW97umicueTyeyJNwmEV@postgresql.org X-Gm-Message-State: AOJu0YzgxtbXSxU3YS+yHUNqyJMkTEP4K7VjbeMEdAe/L70FDBpNtH0C KreZBfMdNRIWCaXB3JOlG3l34Wvm4EOZvETcSfn8fiHWPTkvcG0hlP1/ZLPJ0xla7JlbHZtqisP LmOfUffpHBIhw/4ity7dumOQsuxkcf0M= X-Gm-Gg: AZuq6aJSqEp1jTzMXbBiApBlqBYZX/ekjSLmHAzG43zrinjvolJsDEt0wOSqXbfNdAQ iMmZ+7Rthw5c65x/VDQHmJCDarRISsVPjf+pzwIVtg5RUjLap5WbSdDataC6XREV1sA70vmFbzk o8UJo8I0+PVkDpl+J0sFfO5d+X3VS689fwhsF2C0DbxcnO/fuSQUk2vbPXZKeHJcOY1Xw9GGsXm +a+ioJZAnAy5d8JUCtoEMNol4p+quqoIYkWRW1CORr73ERqmhYMSF+vuKWcBKRdJM3XEyJ8m/Ui W1cv208= X-Received: by 2002:a05:7301:6884:b0:2ae:579d:2038 with SMTP id 5a478bee46e88-2bd5003727dmr4660669eec.4.1771581047003; Fri, 20 Feb 2026 01:50:47 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Nazir Bilal Yavuz Date: Fri, 20 Feb 2026 12:50:35 +0300 X-Gm-Features: AaiRm52kdAKFAZIYqIES-tks__NipfBlsjMJCo1zPpJOqavrRzxwh2mvEdmQEnc Message-ID: Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD To: Manni Wood Cc: KAZAR Ayoub , Nathan Bossart , Neil Conway , Andrew Dunstan , 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 Fri, 20 Feb 2026 at 03:09, Manni Wood wrot= e: > > Thanks for running benchmarks, Ayoub. > > Nazir, I ran my benchmarks with more rows this time --- as many rows as w= ould fit on my test computers without exhausting their RAM disks. That see= ms to have brought things more into line with what Ayoub saw. I did get som= e small regressions, but I suspect those are not a big deal. (For instance,= on both machines I also noticed the occasional "truncate table" would take= longer than the others, despite my scripts' best efforts to steady a CPU c= ore and pin postmaster and children to that core.) Thank you both for the benchmarks. Results look good to me! --=20 Regards, Nazir Bilal Yavuz Microsoft