Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q53gL-0000Tw-PZ for pgsql-general@arkaria.postgresql.org; Fri, 02 Jun 2023 12:15:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q53gJ-0002Fv-Rr for pgsql-general@arkaria.postgresql.org; Fri, 02 Jun 2023 12:14:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q53gJ-0002Fl-H1 for pgsql-general@lists.postgresql.org; Fri, 02 Jun 2023 12:14:59 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q53gB-003gS5-QW for pgsql-general@lists.postgresql.org; Fri, 02 Jun 2023 12:14:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:Subject:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=EVmViCW19Nt21kmqFLMM8p1pDk1kvJ8GJKVD59jkou4=; b=MKwrDAvRObueCyU42IPobDalO8 vaky7nPGGz2UOKVe9P94iL92BeRRXBxqWL3bXxiXv+Z6l4j2bFkIBGDi5gJBOvhp8cohntK2WIXm/ HonMf/jlenFG2Ox1mbPdLCBHDGnbDkHKvQF/Moui57UcQFfHi0GVRgvm/GDN2WzHT6xzXD0M9uV+P tNZZRT1Bz/FDtMpYHypKB5+XsfMFarDXzFB9ZHZ5r2EQWA/bwI4Reut8QMlcRvyEsVQHUbQIGTsHC gYhxlTUQ1VN2m2rOXdmSJm96u+/NnvDJcHZD4l+Z+wwB5kmbJ12j7gcGTHpESG4OA6e7O+4BfXIH9 P+ggE37g==; Received: from [147.129.179.106] (helo=[172.20.3.23]) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q53g9-009mFm-5K; Fri, 02 Jun 2023 12:14:51 +0000 Message-ID: Date: Fri, 2 Jun 2023 08:14:45 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Content-Language: en-US To: David Rowley , Bruce Momjian Cc: Ron , pgsql-general@lists.postgresql.org, Andres Freund References: <7e1a8736-d74c-8de1-679f-f47b250a13cc@gmail.com> From: "Jonathan S. Katz" Subject: Re: Pg 16: will pg_dump & pg_restore be faster? In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------6L64nuEuTyb5yBwaPBGMK3Jd" X-Host-Lookup-Failed: Reverse DNS lookup failed for 147.129.179.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------6L64nuEuTyb5yBwaPBGMK3Jd Content-Type: multipart/mixed; boundary="------------TnTqJI0wnFGnDIMoeEaw4wR5"; protected-headers="v1" From: "Jonathan S. Katz" To: David Rowley , Bruce Momjian Cc: Ron , pgsql-general@lists.postgresql.org, Andres Freund Message-ID: Subject: Re: Pg 16: will pg_dump & pg_restore be faster? References: <7e1a8736-d74c-8de1-679f-f47b250a13cc@gmail.com> In-Reply-To: --------------TnTqJI0wnFGnDIMoeEaw4wR5 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNS8zMC8yMyAxMDowNSBQTSwgRGF2aWQgUm93bGV5IHdyb3RlOg0KDQo+IE15IHVuZGVy c3RhbmRpbmcgaGFkIGJlZW4gdGhhdCBjb25jdXJyZW5jeSB3YXMgcmVxdWlyZWQsIGJ1dCBJ IHNlZSB0aGUNCj4gY29tbWl0IG1lc3NhZ2UgZm9yIDAwZDFlMDJiZSBtZW50aW9uczoNCj4g DQo+PiBFdmVuIHNpbmdsZSB0aHJlYWRlZA0KPj4gQ09QWSBpcyBtZWFzdXJhYmx5IGZhc3Rl ciwgcHJpbWFyaWx5IGR1ZSB0byBub3QgZGlydHlpbmcgcGFnZXMgd2hpbGUNCj4+IGV4dGVu ZGluZywgaWYgc3VwcG9ydGVkIGJ5IHRoZSBvcGVyYXRpbmcgc3lzdGVtIChzZWUgY29tbWl0 IDRkMzMwYTYxYmIxKS4NCj4gDQo+IElmIHRoYXQncyB0aGUgY2FzZSB0aGVuIG1heWJlIHRo ZSBiZXRhIHJlbGVhc2Ugbm90ZXMgY291bGQgYmUgZWRpdGVkDQo+IHNsaWdodGx5IHRvIHJl ZmxlY3QgdGhpcy4gTWF5YmUgc29tZXRoaW5nIGxpa2U6DQo+IA0KPiAiUmVsYXRpb24gZXh0 ZW5zaW9ucyBoYXZlIGJlZW4gaW1wcm92ZWQgYWxsb3dpbmcgZmFzdGVyIGJ1bGsgbG9hZGlu Zw0KPiBvZiBkYXRhIHVzaW5nIENPUFkuIFRoZXNlIGltcHJvdmVtZW50cyBhcmUgbW9yZSBz aWduaWZpY2FudCB3aGVuDQo+IG11bHRpcGxlIHByb2Nlc3NlcyBhcmUgY29uY3VycmVudGx5 IGxvYWRpbmcgZGF0YSBpbnRvIHRoZSBzYW1lIHRhYmxlLiINCj4gDQo+IFRoZSBjdXJyZW50 IHRleHQgb2YgIlBvc3RncmVTUUwgMTYgY2FuIGFsc28gaW1wcm92ZSB0aGUgcGVyZm9ybWFu Y2Ugb2YNCj4gY29uY3VycmVudCBidWxrIGxvYWRpbmcgb2YgZGF0YSB1c2luZyBDT1BZIHVw IHRvIDMwMCUuIiBkb2VzIGxlYWQgbWUNCj4gdG8gYmVsaWV2ZSB0aGF0IG5vdGhpbmcgaGFz IGJlZW4gZG9uZSB0byBpbXByb3ZlIHRoaW5ncyB3aGVuIG9ubHkgYQ0KPiBzaW5nbGUgYmFj a2VuZCBpcyBpbnZvbHZlZC4NCg0KVHlwaWNhbGx5IG9uY2UgYSByZWxlYXNlIGFubm91bmNl bWVudCBpcyBvdXQsIHdlJ2xsIG9ubHkgZWRpdCBpdCBpZiBpdCdzIA0KaW5hY2N1cmF0ZS4g SSBkb24ndCB0aGluayB0aGUgc3RhdGVtZW50IGluIHRoZSByZWxlYXNlIGFubm91bmNlbWVu dCBpcyANCmluYWNjdXJhdGUsIGFzIGl0IHNwZWNpZmllcyB0aGF0IGNvbmN1cnJlbnQgYnVs ayBsb2FkaW5nIGlzIGZhc3Rlci4NCg0KSSBoYWQgYmFzZWQgdGhlIGRlc2NyaXB0aW9uIG9u IHdoYXQgQW5kcmVzIGRlc2NyaWJlZCBpbiB0aGUgb3JpZ2luYWwgDQpkaXNjdXNzaW9uIGFu ZCB0aHJvdWdoIHJlYWRpbmdbMV0sIHdoaWNoIHNob3dlZCBhICJtZWFzdXJhYmxlIiANCmlt cHJvdmVtZW50IGFzIHRoZSBjb21taXQgbWVzc2FnZSBzYWlkLCBidXQgaXQgd2FzIG5vdCB0 byB0aGUgc2FtZSANCmRlZ3JlZSBhcyBjb25jdXJyZW50bHkgbG9hZGluZy4gSXQgZG9lcyBz dGlsbCBzZWVtIGltcGFjdGZ1bCAtLSB0aGUgDQpyZXN1bHRzIHNob3cgdXAgdG8gMjAlIGlt cHJvdmVtZW50IG9uIGEgc2luZ2xlIGJhY2tlbmQgLS0gYnV0IHRoZSBiaWdnZXIgDQpzdG9y eSB3YXMgYXJvdW5kIHRoZSBjb25jdXJyZW5jeS4NCg0KSSdtIC0wLjUgZm9yIHJldmlzaW5n IHRoZSBhbm5vdW5jZW1lbnQsIGJ1dCBJIGFsc28gZG9uJ3Qgd2FudCBwZW9wbGUgdG8gDQpt aXNzIG91dCBvbiB0ZXN0aW5nIHRoaXMuIEknZCBiZSBPSyB3aXRoIHRoaXM6DQoNCiJQb3N0 Z3JlU1FMIDE2IGNhbiBhbHNvIGltcHJvdmUgdGhlIHBlcmZvcm1hbmNlIG9mIGJ1bGsgbG9h ZGluZyBvZiBkYXRhLCANCndpdGggc29tZSB0ZXN0cyBzaG93aW5nIHVzaW5nIHVwIHRvIDMw MCUgaW1wcm92ZW1lbnQgd2hlbiBjb25jdXJyZW50bHkgDQpleGVjdXRpbmcgYENPUFlgIGNv bW1hbmRzLiINCg0KVGhhbmtzLA0KDQpKb25hdGhhbg0KDQpbMV0gDQpodHRwczovL3d3dy5w b3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkLzIwMjIxMDI5MDI1NDIwLmVwbHlvdzZrN3RndTZo ZTNAYXdvcmszLmFuYXJhemVsLmRlDQoNCg== --------------TnTqJI0wnFGnDIMoeEaw4wR5-- --------------6L64nuEuTyb5yBwaPBGMK3Jd Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmR53TUFAwAAAAAACgkQ8QSccp8cZSf3 0hAAje+kbZ1Wzfyg64JyVcDYkyv01Xyk1tGoJ0I8w8njXg+8wH5QagcgDz8ep0YwqllbajdwoKix n928VgBjVGgZACRMbr8+UBucL64KMKaYZ7U+6LgdA2DW9Z/DsSC+4/tsYIkNMhCAbTpntgITDUx9 /7fPKWHwTjTQmn4nG/e9G7AAtGuOwL6GnQ6TNVVx0eJvEmxFA/kzlrAKnfCyVj1WtPuy2Ky8OwiY 4FsddyLYX6oZQx8QhIwezYTeL5CA9xvlBRhAfjID32Sr9GIxRnMca4Ybp5HiO3SPNsS7BadnuBwr pUxBqsd1OonsIGsvT6z1kB6iPkHsRSvaNfjOQYUnYKmWrSUekVE0Zli1KFY/dMr5IIXs6BQf8bhb O+j18RlCTmGYb67xOjePLHIRkji+tnsmFEiXP5M/IsBSkxvlSPCCTh7HpeOHMNeoRdcv3VHX38Mf LS4OElIfvWVRBDRVJv9MC+2fAG+b56Ptwlwrz9qsd4GEKoPHa6xpD4zhk25Ja52pQil1Mn957Sq8 +nwMTa2oCRuh73IaJLSSvTaQTNX9+yIqULcwi1DiAb7k56BP6qbDy8GWztAHiaWQkfZTY0Vxk2f7 1TLpnj7hg21srBGf6pRacbOKx9N7g+/hvvsUTpsmyEzVE9HMUfMnhx7NeA1mb12aS9dNBZUYH6pI neE= =5Kxv -----END PGP SIGNATURE----- --------------6L64nuEuTyb5yBwaPBGMK3Jd--