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 1vyaKs-000EYs-2h for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Mar 2026 18:55:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyaKr-006ZEo-0y for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Mar 2026 18:55:41 +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 1vyaKq-006ZEg-31 for pgsql-hackers@lists.postgresql.org; Fri, 06 Mar 2026 18:55:41 +0000 Received: from mail-dl1-x1233.google.com ([2607:f8b0:4864:20::1233]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vyaKp-00000000oTU-2m0J for pgsql-hackers@postgresql.org; Fri, 06 Mar 2026 18:55:40 +0000 Received: by mail-dl1-x1233.google.com with SMTP id a92af1059eb24-1279eced0b9so8638849c88.0 for ; Fri, 06 Mar 2026 10:55:39 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772823339; cv=none; d=google.com; s=arc-20240605; b=D9C+Rrli/qGk3V/+rnnag/Q82uYAb/xchlD0BAJpVRNYYqsd2yOGP/Xl76dWeje056 THIqn//59ieVTHN52RmeHbg1Nsa2wQqyaI68rvTTsOL13BZcyfYwTLWcLQp5Wix/gb5p 5UiLxsg9K/JuGc2r3IAIvuHCR1qQ3Mx3gs9uH388bx9pIPB5DUtv/BotvbzVjTb2bZNz B1SJ+MSIO2KGteZfntW3XHN0jYT6KsWdnLXoM+AsgauMvGf8UW9PJZUoo2p01GXOHaoO TirT3db5FmENoqs6+pI3RMBnQHRqQumnxdAlcBJzviH5KKBJlUksyMd3fvP1zEcRCLx3 N4gg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=oLpZGJ6+XYEcBljYI0TBaUOYbq02HnOiFaJCNkbDHSI=; fh=0ZSN+kuHTmgMM0fCn530BKTGeEyKXHKAHeqW6LQI/88=; b=XXQkHcWJG6EYYqIcKZ+bB3At8iEMJAgx445c8x7S/XMn+wEHJ7IoKGyAnSEZN6Fmtj h7jlNaL0LYrHCP1jSVPiVuMfHmSwd/Ayy7bhfF93r5/9JR74rp6PzJ7owNBcFXtdgvzX J01sAteJldVZ/PzJn7gVoIGwKHh9bL/qFF0dfsD6WRfkmJfYcyV/sXXaMW9ZpLfhHfMO Zmufoba9nxaMpOkjumoxyV+aMW4hOXQpxOxMmGWgHEczJm/d2sA8m0gcg4Al5FeG78KP N7JsjklTihuLdz4rUxz7d9gV2JtSwgWYOXlUKjKuUqjIHOLuqtAOEft66DHM79KmWBKz Jw7Q==; 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=1772823339; x=1773428139; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=oLpZGJ6+XYEcBljYI0TBaUOYbq02HnOiFaJCNkbDHSI=; b=hfxtu9KkN3C4XVSnztJ7wtxMXWC+M1saIIyD6TQ+pfEw9qtDG9O3Wys1OicKqTmLjr JBQV4ZurWgRYdtdGC3ErFJuKgoRJlus3+7Hnf8I4t2phuvA+FuWY8lerthQUcwQhWZMU IK/3ILeqX2Yudjbjquoa0kKg9llkrf5MhR6bAaDqbvSDMIJgMM4rEqMyIdEQXu7ecxjl rAN0/llGsHNA6AWbX3e0uQIOIs1p7co/Awi7d7v6zqfiz5SWFpMiL3+RSoGFoqWBB1AL yW6wlxBiFB1cDFc82XI/jEqC0HngvzdXFngYVWDQ2T8Q+1arwHfxcvuLmvTH1eWQqOpD SoKg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772823339; x=1773428139; h=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=oLpZGJ6+XYEcBljYI0TBaUOYbq02HnOiFaJCNkbDHSI=; b=N1QZdhRkWT6XhdxtpZSgTNyHBxyxqWhSfa2GU/ZReJ2BLqcO5uQcD3xyRYvFdagN6Q xVKD6SO2mRHEZdFysa+utDXthdha9pw+GSCBbiVhLf02j/PHfZMdEM8bHmUVpADv6RII IRkhV8zfqByzJR1TRJOXD6ZbvWq4YWUk/HCcABP4qhgIoYQTs/DA9n++B8yYHQQfCA1N AWJPBKVxcN5uTtEjc32jgT/dePZ651xolImYFuP5pTKpzLmURAuLAz8V3Uibdgn9p6Dl 8/10CbkVy0K9vDoLryXanGAO3okzbVdzAgBXFVbizwohFf73rmhx/hcHVe/C0SDb45zK 2kSQ== X-Forwarded-Encrypted: i=1; AJvYcCUYB1MVVCVeQrPwTZXUK1lZuvI+80bV+8UAjihHXHn+ZCSxLhmjhX0OE6IIrkw+wMOtH9c2cfzzyjoKY6ZO@postgresql.org X-Gm-Message-State: AOJu0Yx7JX0NNCGLet58zOMBLCOdREQXKh371DnEinmaTU3ySHudNBmy B+IneCOck8iBxo2aO3tYGNKX5vLW3OlDj207eOt8WmLZzJJMQSKAfc1tB6SUUNJ7gz2mNjFv8xN uErSR2qpq/ZeaGptJQwbPZImP38ZmJCk= X-Gm-Gg: ATEYQzxWdqHW7i1Z4Ge3YZ0j+OI28fifMVoiZthJZB45r/0YEby6g5AbEY6lMwri7if Ez3aP7oTtxyaomSchNDgydnnGAMNGSORnN2o981zMUeRtrAE+/PWb93GIcmKUxiaaMgGCtdyScX 5Wa+W2dkuRvJbpc2Bvj2t98Bz3DFdEO7skSA/HpQ9SrPxZOHwdvchqn9atrGsndPKhJDJeeHrD9 duSTaxbHdk/WwBWmKQh71jXNasqRhUvbeaNtl0Eh7hNs2SLZRyKUrqvd8VeI990Uqjq2YuPxMVQ 31yRGTM= X-Received: by 2002:a05:7301:1688:b0:2ba:6fbb:5e7f with SMTP id 5a478bee46e88-2be4e0a0a3dmr1007368eec.35.1772823338615; Fri, 06 Mar 2026 10:55:38 -0800 (PST) MIME-Version: 1.0 References: <91acb778-42c4-44ef-8888-f18ad9b12a5b@dunslane.net> In-Reply-To: From: Nazir Bilal Yavuz Date: Fri, 6 Mar 2026 21:55:26 +0300 X-Gm-Features: AaiRm52UEKiWUgUH1cuCP9ECuDlyRdZNsWQsNuKjgyZ4Q4VBNsS7WxDECjrKzcw Message-ID: Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD To: Manni Wood Cc: Andrew Dunstan , Nathan Bossart , KAZAR Ayoub , Neil Conway , Shinya Kato , PostgreSQL-development Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Manni! On Fri, 6 Mar 2026 at 21:13, Manni Wood wrote: > > When I ran `meson setup build --buildtype=debugoptimized` on both my x86 machine and my arm machine, the response on both was: > > "External libraries > " lz4 : NO" > > However, I did not remove commit 34dfca2934 from any of my Postgres builds; I left that commit in place. > > Let me know if that helps! That definitely helps, thanks! If you have a chance, could you also run the benchmark with LZ4 enabled? I expect you may see significantly better performance, similar to what I observed. -- Regards, Nazir Bilal Yavuz Microsoft