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 1n3KwQ-0007Sq-8f for pgsql-committers@arkaria.postgresql.org; Fri, 31 Dec 2021 16:39:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n3KwO-0002A6-Qj for pgsql-committers@arkaria.postgresql.org; Fri, 31 Dec 2021 16:39:40 +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 1n3KwO-00029w-Jc for pgsql-committers@lists.postgresql.org; Fri, 31 Dec 2021 16:39:40 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n3KwL-0004qA-Rp for pgsql-committers@lists.postgresql.org; Fri, 31 Dec 2021 16:39:40 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n3KwJ-0004gf-R3 for pgsql-committers@lists.postgresql.org; Fri, 31 Dec 2021 16:39:35 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n3KwJ-0000Wk-5h for pgsql-committers@lists.postgresql.org; Fri, 31 Dec 2021 16:39:35 +0000 Content-Type: multipart/mixed; boundary="===============7546736068648022661==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: pg_dump: minor performance improvements from eliminating sub-SEL X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 31 Dec 2021 16:39:35 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7546736068648022661== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 cGdfZHVtcDogbWlub3IgcGVyZm9ybWFuY2UgaW1wcm92ZW1lbnRzIGZyb20gZWxpbWluYXRpbmcg c3ViLVNFTEVDVHMuCgpHZXQgcmlkIG9mIHRoZSAidXNlcm5hbWVfc3VicXVlcnkiIG1lY2hhbmlz bSBpbiBmYXZvciBvZiBkb2luZwpsb2NhbCBsb29rdXBzIG9mIHJvbGUgbmFtZXMgZnJvbSByb2xl IE9JRHMuICBUaGUgUEcgYmFja2VuZCBpc24ndAp0ZXJyaWJseSBzbWFydCBhYm91dCBzY2FsYXIg U3ViTGlua3MgaW4gU0VMRUNUIG91dHB1dCBsaXN0cywKc28gdGhpcyBvZmZlcnMgYSBzbWFsbCBw ZXJmb3JtYW5jZSBpbXByb3ZlbWVudCwgYXQgbGVhc3QgaW4KaW5zdGFsbGF0aW9ucyB3aXRoIG1v cmUgdGhhbiBhIGNvdXBsZSBvZiB1c2Vycy4gIEluIGFueSBjYXNlCnRoZSBvbGQgbWV0aG9kIGRp ZG4ndCBtYWtlIGZvciBwYXJ0aWN1bGFybHkgcmVhZGFibGUgU1FMIGNvZGUuCgpXaGlsZSBhdCBp dCwgSSByZW1vdmVkIHRoZSB2YXJpb3VzIGN1c3RvbSB3YXJuaW5nIG1lc3NhZ2VzIGFib3V0CmZh aWxpbmcgdG8gZmluZCBhbiBvYmplY3QncyBvd25lciwgaW4gZmF2b3Igb2YganVzdCBmYXRhbCdp bmcKaW4gdGhlIGxvY2FsIGxvb2t1cCBmdW5jdGlvbi4gIEFGQUlLIHRoZXJlIGlzIG5vIHJlYXNv biBhbnkKbG9uZ2VyIHRvIHRyZWF0IHRoYXQgYXMgYW55dGhpbmcgYnV0IGEgY2F0YWxvZy1jb3Jy dXB0aW9uIGNhc2UsCmFuZCBjZXJ0YWlubHkgbm8gcmVhc29uIHRvIG1ha2UgdHJhbnNsYXRvcnMg ZGVhbCB3aXRoIGEgZG96ZW4KZGlmZmVyZW50IG1lc3NhZ2VzIHdoZXJlIG9uZSB3b3VsZCBkby4g IChJZiBpdCB0dXJucyBvdXQgdGhhdApmYXRhbCgpIGlzIGluZGVlZCBhIGJhZCBpZGVhLCB3ZSBj YW4gYmFjayBvZmYgdG8gaXNzdWluZwpwZ19sb2dfd2FybmluZygpIGFuZCByZXR1cm5pbmcgYW4g ZW1wdHkgc3RyaW5nLCByZXN1bHRpbmcgaW4KdGhlIHNhbWUgYmVoYXZpb3IgYXMgYmVmb3JlLCBl eGNlcHQgbW9yZSBjb25zaXN0ZW50LikKCkFsc28gZHJvcCBhbiBlbnRpcmVseSB1bm5lY2Vzc2Fy eSBzdWItU0VMRUNUIHRvIGNoZWNrIG9uIHRoZQpwZ19kZXBlbmQgc3RhdHVzIG9mIGEgc2VxdWVu Y2UgcmVsYXRpb246IHdlIGFscmVhZHkgaGF2ZSBhCkxFRlQgSk9JTiB0byBmZXRjaCB0aGUgcm93 IG9mIGludGVyZXN0IGluIHRoZSBGUk9NIGNsYXVzZS4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9z dGdyLmVzL20vMjQ2MDM2OS4xNjQwOTAzMzE4QHNzcy5wZ2gucGEudXMKCkJyYW5jaAotLS0tLS0K bWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29t bWl0ZGlmZi9kNWU4OTMwZjUwZTMxZDgzNmQ4NGIzNTNiOWRhZGVkZDUwMDdiYjcwCgpNb2RpZmll ZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5jIHwgMzg5ICsr KysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0Kc3JjL2Jpbi9wZ19k dW1wL3BnX2R1bXAuaCB8ICA0MiArKy0tLQoyIGZpbGVzIGNoYW5nZWQsIDIxNyBpbnNlcnRpb25z KCspLCAyMTQgZGVsZXRpb25zKC0pCgo= --===============7546736068648022661==--