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.94.2) (envelope-from ) id 1rcxzc-003Arj-Aq for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Feb 2024 01:35:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rcxza-007e6a-Ng for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Feb 2024 01:35:19 +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.94.2) (envelope-from ) id 1rcxza-007e6R-EN for pgsql-hackers@lists.postgresql.org; Thu, 22 Feb 2024 01:35:18 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcxzT-000M46-3f for pgsql-hackers@lists.postgresql.org; Thu, 22 Feb 2024 01:35:17 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 425475C00B5; Wed, 21 Feb 2024 20:35:11 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 21 Feb 2024 20:35:11 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1708565711; x=1708652111; bh=WKsRJM7lsC SgTpfr0BBMkj61N4IpDtNsoLD9xztDLeo=; b=f0UDB4CrOzci66R6IFsgc+Fgf5 2scR8j7a6uzn90lUeibThSj8KuPc8lhGAy1WbJujVXJMRwz9aXrrJvHgjltV6Hme Kf7vMrXDQZlsDC8USPNlEoWgB2J8WAO78Asbt860i2kL6xPOTWI1xjRGlO0IboHo 3qVRZjbJsBK0seDUJc8hvW3dLh9/Stv9VJP345AmCcIX4Ho9kpU77rn55AHcqext doOuKLTIWYf5Y5KOrqpRAtP3dopfAVxZrQ3TgL8374/iQiPX2TUc9Pae0tzIFV1D kl1WCyxE0gVEJKI7s8cGjRn/UBlhfB49izVykmUY5Vs0kjUiOgY26459/Ryw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1708565711; x=1708652111; bh=WKsRJM7lsCSgTpfr0BBMkj61N4Ip DtNsoLD9xztDLeo=; b=e9gKPVKvDESJDdzDb7fwcLbQH9+ZRyc5/MsBoI+d4qjm lC3fRMOlbMsPc3Kcjl9lT6t2P5PsGrcC2GNtYt0LdImvM73km3AHjTWBShRjJpND SFDQuvAmpZ3x/5+xGhcOKGXs2u6mTU4ierzu5KTJWl+6Wzi9GZ6WBhnBv0+harSX vqE3p9Yk6YKKzJln8jJVzHc7j3vEabCNUzLoz77odJqBX3NgoEj1L9RqL11MnkLk RApmtLr/1wVsmdMohzZps2XlXOsd/qbMiskFuUcH0xiaRWh3Nc910Ti/QPBNJH2N GxMhptEfYscNK9ZJq1nSDgCLRzAQr/UN+srnAzrlYA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfeefgdefhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeg geffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 21 Feb 2024 20:35:09 -0500 (EST) Date: Thu, 22 Feb 2024 10:34:57 +0900 From: Michael Paquier To: Laurenz Albe Cc: Andres Freund , pgsql-hackers@lists.postgresql.org Subject: Re: Speeding up COPY TO for uuids and arrays Message-ID: References: <679d5455cbbb0af667ccb753da51a475bae1eaed.camel@cybertec.at> <20240217202433.b4f3hbvu45ntld7c@awork3.anarazel.de> <1339b52e16d4977ce59a9d3e91837c1033713930.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="UmpeRtHKwjZRLasf" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --UmpeRtHKwjZRLasf Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Feb 21, 2024 at 02:29:05PM +0900, Michael Paquier wrote: > That's very good, so I'd like to apply this part. Let me know if > there are any objections. This part is done as of 011d60c4352c. I did not evaluate the rest yet. -- Michael --UmpeRtHKwjZRLasf Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmXWpMEACgkQnvQgOdby QH3Rfw//Yea022gMD6Vgd1nrhviAGXWJ257f9box2vmePeDJDRtWjYRECRr9m+0C lSFzlnVaLpNrHkFPEViXplkDWjCKWFmHPsO1fLWl1/hEQEy1/l6imvxnLzxH1MSH TQOXryley0hr+bYOvryN9RpSS/gVBiHS2Dy2oU/F7SkvVjQeQqWv1K/26dBtyikB UUr0bt9i4LyOzWUpYcN1JWqsSofef17jy6Y5d0RJk0kcysU7NviFY5wkMTKSy8Jv YeNCLxITF7mcnBRmcFmnfZmIHgpX9D3JYG40DcBnw7TFJANT6tAoi/vaawuc7Oms bpRcJFvhP92DgDvENFgaQAqbuLn9lBMH+FlkHRcZeSZwjrButhSjrtnzPAh9nuDP Y9W6VCBpv9FYS/feufAQc1O7jzLIXazGBTjLR1RkUmmThs6NJQdf1Mt7Nt+5UBJh ob/vdDLs1XXtU3GdVFwb2+9wCHM6AiIosmsAwwOPwjv++KNELP0xcxZGo/e44rSX Rs555i5Bkb/VggYEQIdLMiFsQU666PvkSaSUepydWutu9b48MO+1Npgn8oBlCpzT jy5fk5rh/Pll2J60g66ENtXjon83g/HLjHrEFEnABlTasltXhWCZXNTxkMuOf0T+ /eOoBTXBigWB37VReQewvipmZP5utZxAPRf/kyMdYN+2r86W9ow= =VddQ -----END PGP SIGNATURE----- --UmpeRtHKwjZRLasf--