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 1rrOYN-000LXx-PE for pgsql-committers@arkaria.postgresql.org; Mon, 01 Apr 2024 20:46:52 +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 1rrOYM-001a5O-8U for pgsql-committers@arkaria.postgresql.org; Mon, 01 Apr 2024 20:46:50 +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 1rrOYM-001a50-1W for pgsql-committers@lists.postgresql.org; Mon, 01 Apr 2024 20:46:50 +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 1rrOYF-0002UU-55 for pgsql-committers@lists.postgresql.org; Mon, 01 Apr 2024 20:46:50 +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 1rrOYD-0004g3-3i for pgsql-committers@lists.postgresql.org; Mon, 01 Apr 2024 20:46:41 +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 1rrOYC-00020N-4k for pgsql-committers@lists.postgresql.org; Mon, 01 Apr 2024 20:46:40 +0000 Content-Type: multipart/mixed; boundary="===============5836226386577687560==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Invent --transaction-size option for pg_restore. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 01 Apr 2024 20:46:40 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5836226386577687560== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW52ZW50IC0tdHJhbnNhY3Rpb24tc2l6ZSBvcHRpb24gZm9yIHBnX3Jlc3RvcmUuCgpUaGlzIHBh dGNoIGFsbG93cyBwZ19yZXN0b3JlIHRvIHdyYXAgaXRzIGNvbW1hbmRzIGludG8gdHJhbnNhY3Rp b24KYmxvY2tzLCBzb21ld2hhdCBsaWtlIC0tc2luZ2xlLXRyYW5zYWN0aW9uLCBleGNlcHQgdGhh dCB3ZSBjb21taXQKYW5kIHN0YXJ0IGEgbmV3IGJsb2NrIGFmdGVyIGV2ZXJ5IE4gb2JqZWN0cy4g IFVzaW5nIHRoaXMgbW9kZQp3aXRoIGEgc2l6ZSBsaW1pdCBvZiAxMDAwIG9yIHNvIG9iamVjdHMg Z3JlYXRseSByZWR1Y2VzIHRoZSBudW1iZXIKb2YgdHJhbnNhY3Rpb25zIGNvbnN1bWVkIGJ5IHRo ZSByZXN0b3JlLCB3aGlsZSBwcmV2ZW50aW5nIGFueQpvbmUgdHJhbnNhY3Rpb24gZnJvbSB0YWtp bmcgZW5vdWdoIGxvY2tzIHRvIG92ZXJydW4gdGhlIHJlY2VpdmluZwpzZXJ2ZXIncyBzaGFyZWQg bG9jayB0YWJsZS4KCihBIHZhbHVlIG9mIDEwMDAgd29ya3Mgd2VsbCB3aXRoIHRoZSBkZWZhdWx0 IGxvY2sgdGFibGUgc2l6ZSBvZgphcm91bmQgNjQwMCBsb2Nrcy4gIEhpZ2hlciAtLXRyYW5zYWN0 aW9uLXNpemUgdmFsdWVzIGNhbiBiZSB1c2VkCmlmIG9uZSBoYXMgaW5jcmVhc2VkIHRoZSByZWNl aXZpbmcgc2VydmVyJ3MgbG9jayB0YWJsZSBzaXplLikKCkV4Y2Vzc2l2ZSBjb25zdW1wdGlvbiBv ZiBYSURzIGhhcyBiZWVuIHJlcG9ydGVkIGFzIGEgcHJvYmxlbSBmb3IKcGdfdXBncmFkZSBpbiBw YXJ0aWN1bGFyLCBidXQgaXQgY291bGQgYmUgYmFkIGZvciBhbnkgcmVzdG9yZTsgYW5kIHRoZQpj aGFuZ2UgYWxzbyByZWR1Y2VzIHRoZSBudW1iZXIgb2YgZnN5bmNzIGFuZCBhbW91bnQgb2YgV0FM IGdlbmVyYXRlZCwKc28gaXQgc2hvdWxkIHByb3ZpZGUgc3BlZWQgYmVuZWZpdHMgdG9vLgoKVGhp cyBwYXRjaCBkb2VzIG5vdCB0cnkgdG8gbWFrZSBwYXJhbGxlbCB3b3JrZXJzIGJhdGNoIHRoZSBT UUwKY29tbWFuZHMgdGhleSBpc3N1ZS4gIFRoZSB0cm91YmxlIHdpdGggZG9pbmcgdGhhdCBpcyB0 aGF0IG90aGVyCndvcmtlcnMgbWF5IG5lZWQgdG8gc2VlIHRoZSBvYmplY3RzIGEgd29ya2VyIGNy ZWF0ZXMgcmlnaHQgYXdheS4KUG9zc2libHkgdGhpcyBjYW4gYmUgaW1wcm92ZWQgbGF0ZXIuCgpJ biB0aGlzIHBhdGNoIEkgaGF2ZSBoYXJkLXdpcmVkIHBnX3VwZ3JhZGUgdG8gdXNlIGEgdHJhbnNh Y3Rpb24gc2l6ZQpvZiAxMDAwIGRpdmlkZWQgYnkgdGhlIG51bWJlciBvZiBwYXJhbGxlbCByZXN0 b3JlIGpvYnMgYWxsb3dlZAood2l0aG91dCB0aGF0LCB3ZSdkIHN0aWxsIGJlIGF0IHJpc2sgb2Yg b3ZlcnJ1bm5pbmcgdGhlIHNoYXJlZCBsb2NrCnRhYmxlKS4gIFBlcmhhcHMgdGhlcmUgd291bGQg YmUgdmFsdWUgaW4gYWRkaW5nIGFub3RoZXIgcGdfdXBncmFkZQpvcHRpb24gdG8gYWxsb3cgdXNl ciBjb250cm9sIG9mIHRoYXQsIGJ1dCBJJ20gdW5zdXJlIHRoYXQgaXQncyB3b3J0aAp0aGUgdHJv dWJsZTsgSSB0aGluayBmZXcgdXNlcnMgd291bGQgdXNlIGl0LCBhbmQgYW55IHdobyBkaWQgd291 bGQgc2VlCm5vdCB0aGF0IG11Y2ggYmVuZWZpdCBjb21wYXJlZCB0byB0aGUgZGVmYXVsdC4KClBh dGNoIGJ5IG1lLCBidXQgdGhlIG9yaWdpbmFsIGlkZWEgdG8gYmF0Y2ggU1FMIGNvbW1hbmRzIGR1 cmluZwpyZXN0b3JlIGlzIGR1ZSB0byBSb2JpbnMgVGhhcmFrYW4uCgpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tL2E5ZjkzNzZmMWMzMzQzYTZiYjMxOWRjZTI5NGUyMGFjQEVYMTNEMDVV V0MwMDEuYW50LmFtYXpvbi5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0t LS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85NTliMzhkNzcwYmEx ZjhmMzVlZGFiMjdlZjNjY2Y4YjFkOTlmNWRkCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0t LQpkb2Mvc3JjL3NnbWwvcmVmL3BnX3Jlc3RvcmUuc2dtbCAgICAgfCAgMjQgKysrKysrCnNyYy9i aW4vcGdfZHVtcC9wZ19iYWNrdXAuaCAgICAgICAgICB8ICAgNCArLQpzcmMvYmluL3BnX2R1bXAv cGdfYmFja3VwX2FyY2hpdmVyLmMgfCAxMzkgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysr KysrLS0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2JhY2t1cF9hcmNoaXZlci5oIHwgICAzICsKc3JjL2Jp bi9wZ19kdW1wL3BnX2JhY2t1cF9kYi5jICAgICAgIHwgIDE4ICsrKysrCnNyYy9iaW4vcGdfZHVt cC9wZ19yZXN0b3JlLmMgICAgICAgICB8ICAxNSArKystCnNyYy9iaW4vcGdfdXBncmFkZS9wZ191 cGdyYWRlLmMgICAgICB8ICAyNSArKysrKysrCjcgZmlsZXMgY2hhbmdlZCwgMjIwIGluc2VydGlv bnMoKyksIDggZGVsZXRpb25zKC0pCgo= --===============5836226386577687560==--