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 1sYT5N-00Back-Ve for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 16:18:57 +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 1sYT5M-000tNu-8T for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 16:18:56 +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 1sYT49-000rTd-GH for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:41 +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 1sYT44-0025pc-M9 for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:38 +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 1sYT42-006TFz-Vr for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:34 +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 1sYT42-001lYg-CR for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:34 +0000 Content-Type: multipart/mixed; boundary="===============7884267296708364049==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Count individual SQL commands in pg_restore's --transaction-size X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Jul 2024 16:17:34 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7884267296708364049== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q291bnQgaW5kaXZpZHVhbCBTUUwgY29tbWFuZHMgaW4gcGdfcmVzdG9yZSdzIC0tdHJhbnNhY3Rp b24tc2l6ZSBtb2RlLgoKVGhlIGluaXRpYWwgaW1wbGVtZW50YXRpb24gaW4gY29tbWl0IDk1OWIz OGQ3NyBjb3VudGVkIG9uZSBhY3Rpb24KcGVyIFRPQyBlbnRyeSAoZXhjZXB0IGZvciBzb21lIHNw ZWNpYWwgY2FzZXMgZm9yIG11bHRpLWJsb2IgQkxPQlMKZW50cmllcykuICBUaGlzIGFzc3VtZXMg dGhhdCBUT0MgZW50cmllcyBhcmUgYWxsIGFib3V0IGVxdWFsbHkKY29tcGxleCwgYnV0IGl0IHR1 cm5zIG91dCB0aGF0IHRoYXQgYXNzdW1wdGlvbiBkb2Vzbid0IGhvbGQgdXAgdmVyeQp3ZWxsIGlu IGJpbmFyeS11cGdyYWRlIG1vZGUuICBGb3IgZXhhbXBsZSwgZXZlbiBhZnRlciB0aGUgcHJldmlv dXMKY29tbWl0IEkgd2FzIGFibGUgdG8gY2F1c2UgYmFja2VuZCBibG9hdCB3aXRoIHRhYmxlcyBo YXZpbmcgbWFueQppbmhlcml0ZWQgY29uc3RyYWludHMuICBUaGVyZSBtYXkgYmUgb3RoZXIgY2Fz ZXMgdG9vLiAgKFNpbmNlIG5vCnNlcmlvdXMgcHJvYmxlbXMgaGF2ZSBiZWVuIHJlcG9ydGVkIHdp dGggLS1zaW5nbGUtdHJhbnNhY3Rpb24gbW9kZSwKd2UgY2FuIGNvbmNsdWRlIHRoYXQgdGhlIGJh Y2tlbmQgY29wZXMgd2VsbCB3aXRoIHBzcWwncyByZWd1bGFyCnJlc3RvcmUgc2NyaXB0czsgYnV0 IGJlZm9yZSA5NTliMzhkNzcgd2UgbmV2ZXIgcmFuIGJpbmFyeS11cGdyYWRlCnJlc3RvcmVzIHdp dGggbXVsdGktY29tbWFuZCB0cmFuc2FjdGlvbnMuKQoKVG8gZml4LCBjb3VudCBtdWx0aS1jb21t YW5kIFRPQyBlbnRyaWVzIGFzIE4gYWN0aW9ucywgYWxsb3dpbmcgdGhlCnRyYW5zYWN0aW9uIHNp emUgdG8gYmUgc2NhbGVkIGRvd24gd2hlbiB3ZSBoaXQgYSBjb21wbGV4IFRPQyBlbnRyeS4KUmF0 aGVyIHRoYW4gYWRkIGEgU1FMIHBhcnNlciB0byBwZ19yZXN0b3JlLCBhcHByb3hpbWF0ZSAibXVs dGkKY29tbWFuZCIgYnkgY291bnRpbmcgc2VtaWNvbG9ucyBpbiB0aGUgVE9DIGVudHJ5J3MgZGVm biBzdHJpbmcuClRoaXMgd2lsbCBiZSBmb29sZWQgYnkgc2VtaWNvbG9ucyBhcHBlYXJpbmcgaW4g c3RyaW5nIGxpdGVyYWxzIC0tLQpidXQgdGhlIGVycm9yIGlzIGluIHRoZSBjb25zZXJ2YXRpdmUg ZGlyZWN0aW9uLCBzbyBpdCBkb2Vzbid0IHNlZW0Kd29ydGggd29ya2luZyBoYXJkZXIuICBUaGUg YmlnZ2VzdCByaXNrIGlzIHdpdGggZnVuY3Rpb24vcHJvY2VkdXJlClRPQyBlbnRyaWVzLCBidXQg d2UgY2FuIGp1c3QgZXhwbGljaXRseSBza2lwIHRob3NlLgoKKFRoaXMgaXMgdW5kb3VidGVkbHkg YSBoYWNrLCBhbmQgbWF5YmUgc29tZWRheSB3ZSdsbCBiZSBhYmxlIHRvCnJldmVydCBpdCBhZnRl ciBmaXhpbmcgdGhlIGJhY2tlbmQncyBibG9hdCBpc3N1ZXMgb3IgcmV0aGlua2luZwp3aGF0IHBn X2R1bXAgZW1pdHMgaW4gYmluYXJ5IHVwZ3JhZGUgbW9kZS4gIEJ1dCB0aGF0IHN1cmVseSBpc24n dAphIHByb2plY3QgZm9yIHYxNy4pCgpUaGFua3MgdG8gQWxleGFuZGVyIEtvcm90a292IGZvciB0 aGUgbGV0J3MtY291bnQtc2VtaWNvbG9ucyBpZGVhLgoKUGVyIHJlcG9ydCBmcm9tIEp1c3RpbiBQ cnl6YnkuICBCYWNrLXBhdGNoIHRvIHYxNyB3aGVyZSB0eG5fc2l6ZSBtb2RlCndhcyBpbnRyb2R1 Y2VkLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9acUVORDRaY1REQm1jdjMxQHBy eXpieWoyMDIzCgpCcmFuY2gKLS0tLS0tClJFTF8xN19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzgxZGIwNzNhMjg3ODQyY2Jm MGExN2NiMzIxMDhiMjE0YTMzNTY3MGIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iaW4vcGdfZHVtcC9wZ19iYWNrdXBfYXJjaGl2ZXIuYyB8IDI4ICsrKysrKysrKysrKysrKysr KysrKysrKystLS0KMSBmaWxlIGNoYW5nZWQsIDI1IGluc2VydGlvbnMoKyksIDMgZGVsZXRpb25z KC0pCgo= --===============7884267296708364049==--