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 1rd3Vc-003bZ4-Sy for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Feb 2024 07:28:45 +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 1rd3Ud-008vkw-41 for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Feb 2024 07:27:43 +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.94.2) (envelope-from ) id 1rd3Uc-008vkn-Qu for pgsql-hackers@lists.postgresql.org; Thu, 22 Feb 2024 07:27:43 +0000 Received: from wfhigh3-smtp.messagingengine.com ([64.147.123.154]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rd3UY-000Ibl-Jo for pgsql-hackers@lists.postgresql.org; Thu, 22 Feb 2024 07:27:42 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfhigh.west.internal (Postfix) with ESMTP id 11DF718000A7; Thu, 22 Feb 2024 02:27:33 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 22 Feb 2024 02:27:34 -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=1708586853; x=1708673253; bh=YuGzJKrLhc DADSyxwnnXQooVtF2BqcAHd41eMP2yTO8=; b=WYA/dw4yR210BoC/F3kTQL0Ne0 8Vt+9zsNzUZolk79OxRpynmjF553ZTjf4OK6hD1alb0eMMO2mCd6MSeLVpSlHNuT H1NVlnf9sf6kl9fNJuKYibhDZy8ejmT2bGjiIcXLUnt8685GRT1LCtT1tS1IqNT7 eKK4BfHET9HLfttXHysUK5/aqRCD+lSO6DFRiY3BOpGamrRr/Qbgd5C03Jm/6ydQ h96Pf+NIUFngZYjQdopKUK8IPfQOZX/yu0oc6yXkXVldc8JXhTMTcWcntgiVtgqD jmvh/5abT3PP9Tcd3JTy2HhVJ5wxoYG6LN0yEyAHQDTSu/Bz4/9pYNs847dA== 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=1708586853; x=1708673253; bh=YuGzJKrLhcDADSyxwnnXQooVtF2B qcAHd41eMP2yTO8=; b=qKKHQTh+KL0QDK+lrk9rTTJ4m1NJEV1SmYV/VeN42PxP PLG2mHm6WilztGeleYCfjW3j5lfLv9Z23TmtEJcWrG/7hHz1BFKEfPdXQeYiv0x1 hRFSkOF8pzfsLy1mIilbtbMe5Q8Gso82H4jhfSb2BmYzmOkomGSnXTO8M0XrdQbI oy5m5KR4bBbhC0kiXahQLpzCrWuo9zBysq+4nF7L1FpbGxu8D2r/wHPBkLADRHoC bB4Y8p72uB5IPHzOenpLgXZvu3fFtAi2B+PyshK1uGoFce5uRLfJekN7klHRac3C EoXdQA6jQJ+hE8QGNHzL7lwXL3Zf8MGX+0b60aRx3A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfeefgddutdeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 22 Feb 2024 02:27:30 -0500 (EST) Date: Thu, 22 Feb 2024 16:27:21 +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> <8e537d6ad8ce4e6a9fb15cb8cd60f3665343109c.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Vf4AEwoSJm2BVYn+" Content-Disposition: inline In-Reply-To: <8e537d6ad8ce4e6a9fb15cb8cd60f3665343109c.camel@cybertec.at> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Vf4AEwoSJm2BVYn+ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Feb 22, 2024 at 08:16:09AM +0100, Laurenz Albe wrote: > I'm attaching the remaining patch for the Juli commitfest, if you > don't get inspired before that. There are good chances that I get inspired some time next week. We'll see ;) -- Michael --Vf4AEwoSJm2BVYn+ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmXW91kACgkQnvQgOdby QH2crBAAovPaUzTvaSr+fF4YOk7QdiRCpdA/lJovLnKHKU79K+TrQYIdvfiIyuIe 6Iy+q0tn8W2tVwgkvtp/kg0tt3de1Y0DjYBkpeYj8102UyyhfGvhCGIfnDqUI8dc QNiJpSTZCZ/IYMScr6o/LC84c4W/Ub9DCGBhkW9ctNwLDyX9KcdWn6ED5mG1tvzA h/nCZ9uK7nBbWZQ+mKrprQaFAdSnFCinvEsbrouTfRuebKSTgYAvTrWpGYPh3bHD yGNIciXPNOIGs+oHnrsPYunUyqNIVJYWB1zbrMJg7Ark8DMNAYnst9focF6Pkabf pxeS0q4w4i2tRgjIx+5HjGYcQr5d1MdmFik3+uqi8TiHwyVWwhPczVeSzJwLSt/T F+G4QJkegJ9UVLKDn8Wyf9lOPBaEVz43yF6M1BPpTDQyGaZyw8xodeGLAj04SKT9 Kil+3DeOv6SVZL9A9zRYL7ORWH435nDUmF2sPMrysq34hq4l8Vl2G3NOFxgLINWo a+w0nzRtnj7V2MU2IQkEmVRnkevb6EfAg+bFB2j+0gIn+0CO1LCyD30OqiVbwMfI 8rU2wkzK5k1S+dZQnqpFXDZzkxgLA32fvGpRqOTt8wKj/mRDbRjT9OAiHVSPDK7c zwU2vR7KSoTPjpnkHxxg4dgTpluisns0/opM1xSI1C8jWUcfStM= =SPMn -----END PGP SIGNATURE----- --Vf4AEwoSJm2BVYn+--