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 1vfjoo-004bU8-1t for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jan 2026 19:12:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vfjon-006BWh-2G for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jan 2026 19:12: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 1vfjon-006BWZ-1J for pgsql-hackers@lists.postgresql.org; Tue, 13 Jan 2026 19:12:41 +0000 Received: from mail-dy1-x1333.google.com ([2607:f8b0:4864:20::1333]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vfjol-000FaR-0g for pgsql-hackers@postgresql.org; Tue, 13 Jan 2026 19:12:40 +0000 Received: by mail-dy1-x1333.google.com with SMTP id 5a478bee46e88-2b1981ca515so4698231eec.1 for ; Tue, 13 Jan 2026 11:12:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1768331559; x=1768936359; 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=P2U4wjuPTWG5le3xcW+3+WZkvrea70HdVJGjC+TvkR4=; b=BXOkClsYswOxab/kPqG41Fv523TTLoJ5rOGRXotBsf7S66J56MTrvZ/tGOi9FRGf/t PChOYQljHJdUjhWlp1IdW+yt2yU3sDFSn/yZUOAD93mieliz0SMMC4Qn+THJQal8KjkR hW6PfGMEzw3MIS0MTmMJjUQcdXKVzMSix4F/AgzPpHFG2OPJlffEymb+KSgQMPe71K/4 cxnln+UNh6A7IFXhiTDmy7lWhlaR0EJeDdvsiETlV9n8v+bf8zWYlPmlZJ38s5bYY0G+ fcbQpAEnwE4YBzOFoLUsNz3CX1HhQzZLN3XwbtRafkxtKsKf8A6kBBdpsJZ+mD6S4MDI KlIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768331559; x=1768936359; 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=P2U4wjuPTWG5le3xcW+3+WZkvrea70HdVJGjC+TvkR4=; b=Rc7wW4ilDdO+cwpSsRefxiFh8Zg9ok2+8RRWf2H/3Kvfdj9A6JsBgGpDxkHvVHwDfN dSSaVjjylPSfh2A1ToxonVkd4MS2DYce/fDoE1RsQwJXQbRYXIXKuvobNvDZHHEROeOz Lj6sM8Fy++qQT0nK4IwhgUgQxj991BcT8UhIdhinlHw9k+YC5oX9kr1DNTzGfWi52Tc8 so7lgAzhLMtEeIDUZmi/AYG7feudXpk3Hnbz4M7rABu2IbtrRSSoyv2pP4SaW9wA9I1Z ccX437kV/8mLxxUaUsVcc6+aey9oONeR5MNv6ObemMdXKUOSREMsizgLgaRxx38m5ddW CZ6g== X-Forwarded-Encrypted: i=1; AJvYcCXXEUtCk9uiNnzWCXa1bWgy5yYEhtFLQOqRYQ5XQ+JG3lTSAv8g9Q8Rh3OjAaJjmLJqilbFRbtRdjL4S22T@postgresql.org X-Gm-Message-State: AOJu0YxYv1P5Q2fhRj+iizv/fGodFQjCs5NuvVMbNlb3OsxNtMKexI+B k3Ii4+S/2HLBb/X5YuLe5bRYRd+vR6UJC6sVak4VU08NJKsLz2tczN1A X-Gm-Gg: AY/fxX60anqPrrSl8/aiOStgTrUVYy2fBcO2HavKz3fEutU+MMcRASqIY0cmvOWIy5C lybolboAaJPYozlZF3YUH6dYIVTGSQq7r2U3CEQ0abenvowO0sYE8TODs0fE5o5PS4p3xxYTnhL QDTUGPE3c33mXNjol0M1MPk53ED4hgT+FOgxb8Ma+qWC4XHIaRLSkSSAZb7C0bCv9AkudacnHoq qLIgvB5/uGkmLv3xz0rHurDFcxTYz2HRNkO6VTE2AIPwDJji2tzr7VW/604LdjAK1Xm9FMhfvzg DT7ABD9xH1bqTIeFZfUvLYFxrZDaCINYo+K1Yn1PfMQUt0SOHPZv6P4ELwZoZlYA3DvyHeU0prA ussUVezVlW5y5Ny8GId1kjjcP1ZnqnORFYVFAa/paF/zlXpsvitCLmoL+J7SHx5UJc8CRpka2Oq 2rdFGjd1jn5hYfSkD3iE4= X-Received: by 2002:a05:7301:5808:b0:2ab:c279:9dce with SMTP id 5a478bee46e88-2b486c89c11mr122369eec.7.1768331558582; Tue, 13 Jan 2026 11:12:38 -0800 (PST) Received: from o (71-34-92-171.ptld.qwest.net. [71.34.92.171]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2b175bee31dsm16332494eec.32.2026.01.13.11.12.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 13 Jan 2026 11:12:37 -0800 (PST) Date: Tue, 13 Jan 2026 11:12:33 -0800 From: Mark Wong To: Nazir Bilal Yavuz Cc: Manni Wood , KAZAR Ayoub , Nathan Bossart , Andrew Dunstan , Shinya Kato , PostgreSQL-development Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD Message-ID: References: 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, Jan 09, 2026 at 05:21:45PM +0300, Nazir Bilal Yavuz wrote: > Were you able to understand why Mark's benchmark results are different > from ours? Not yet... I had some guesses, which is why I suggested the processor pinning and using a ramdisk. But we haven't tried applying all of those to my laptop, which has 3 core types, or the POWER system, which may be interesting to use a ram disk on. I'm curious though, and admittedly haven't tried looking myself yet, about how the SIMD calls might look across different processor architectures. We'll try to get that on the POWER system soon... Regards, Mark -- Mark Wong EDB https://enterprisedb.com