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 1rYEnk-00Ezv2-Fg for pgsql-committers@arkaria.postgresql.org; Fri, 09 Feb 2024 00:31:33 +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 1rYEnj-004hV2-H6 for pgsql-committers@arkaria.postgresql.org; Fri, 09 Feb 2024 00:31:31 +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 1rYEnj-004hT6-8N for pgsql-committers@lists.postgresql.org; Fri, 09 Feb 2024 00:31:31 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rYEng-006DM4-Dm for pgsql-committers@lists.postgresql.org; Fri, 09 Feb 2024 00:31:30 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rYEne-00HHk6-JL for pgsql-committers@lists.postgresql.org; Fri, 09 Feb 2024 00:31:26 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rYEne-005Jmw-16 for pgsql-committers@lists.postgresql.org; Fri, 09 Feb 2024 00:31:26 +0000 Content-Type: multipart/mixed; boundary="===============1926414773801231568==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve COPY TO performance when server and client encodings mat X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 09 Feb 2024 00:31:26 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1926414773801231568== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBDT1BZIFRPIHBlcmZvcm1hbmNlIHdoZW4gc2VydmVyIGFuZCBjbGllbnQgZW5jb2Rp bmdzIG1hdGNoCgpUaGlzIGNvbW1pdCBmaXhlcyBhbiBvdmVyc2lnaHQgaW50cm9kdWNlZCBpbiBj NjFhMmY1ODQxOGUsIHdoZXJlIENPUFkgVE8Kd291bGQgYXR0ZW1wdCB0byBkbyBlbmNvZGluZyBj b252ZXJzaW9ucyBldmVuIGlmIHRoZSBlbmNvZGluZ3Mgb2YgdGhlCmNsaWVudCBhbmQgdGhlIHNl cnZlciBtYXRjaGVkIGZvciBtdWx0aS1ieXRlIGVuY29kaW5ncy4gIEFsbCBjb252ZXJzaW9ucwpn byB0aHJvdWdoIHBnX2FueV90b19zZXJ2ZXIoKSB0aGF0IG1ha2VzIHRoZSBjb252ZXJzaW9uIGEg bm8tb3Agd2hlbiB0aGUKZW5jb2RpbmdzIG9mIHRoZSBjbGllbnQgYW5kIHRoZSBzZXJ2ZXIgbWF0 Y2gsIGV2ZW4gZm9yIG11bHRpLWJ5dGUKZW5jb2RpbmdzLgoKVGhlIGxvZ2ljIHdhcyBmaW5lLCBi dXQgc2V0dGluZyBDb3B5VG9TdGF0ZURhdGEtPm5lZWRfdHJhbnNjb2Rpbmcgd291bGQKY2F1c2Ug c3RybGVuKCkgdG8gYmUgY2FsbGVkIGZvciBub3RoaW5nIGZvciBlYWNoIGF0dHJpYnV0ZSBvZiBh bGwgdGhlCnJvd3MgY29waWVkLCBhbmQgdGhhdCB3YXMgc2hvd2luZyBoaWdoIGluIHNvbWUgcHJv ZmlsZXMgKG1vcmUgYXR0cmlidXRlcwptYWtlIHRoYXQgZWFzaWVyIHRvIHJlYWNoKS4gIFRoaXMg Y2hhbmdlIGltcHJvdmVzIHRoZSBydW50aW1lIG9mIHNvbWUKd29yc3QtY2FzZSBDT1BZIFRPIHF1 ZXJpZXMgYnkgMTUlfiAobnVtYmVyIHByZXNlbnQgYXQgbGVhc3QgaGVyZSkuCgpUaGlzIGlzIGEg cGVyZm9ybWFuY2UgaW1wcm92ZW1lbnQsIHNvIG5vIGJhY2twYXRjaCBpcyBkb25lIG91dCBvZgpj YXV0aW9uIGFzIHRoaXMgaXMgbm90IGEgcmVncmVzc2lvbi4KClJlcG9ydGVkLWJ5OiBBbmRyZXMg RnJldW5kCkFuYWx5emVkLWJ5OiBBbmRyZXMgRnJldW5kCkF1dGhvcjogTWljaGFlbCBQYXF1aWVy ClJldmlld2VkLWJ5OiBIZWlra2kgTGlubmFrYW5nYXMKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS8yMDI0MDIwNjAyMDUwNC5lZGlqemN6a2dkMjVlazZ6QGF3b3JrMy5hbmFyYXplbC5k ZQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0 Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2I2MTk4NTIwODZlZDJiNWRmNzY2MzFmNTY3OGY2MGQz YmViZDM3NDUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1h bmRzL2NvcHl0by5jIHwgMTQgKysrKysrKystLS0tLS0KMSBmaWxlIGNoYW5nZWQsIDggaW5zZXJ0 aW9ucygrKSwgNiBkZWxldGlvbnMoLSkKCg== --===============1926414773801231568==--