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 1sYT4C-00BaTz-AB for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 16:17:44 +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 1sYT49-000rU3-OF for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 16:17:41 +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-000rTh-GI 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-0025pb-Na for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:40 +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-006TFx-V4 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-001lYb-BU for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:34 +0000 Content-Type: multipart/mixed; boundary="===============5094351276684444749==" 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 --===============5094351276684444749== 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 eXpieWoyMDIzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMGYxMjkwNTIxNTA0ODdhZmFiOWZlNjQ4 ODljNWJmNzUzNGY3YmJjMwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jpbi9w Z19kdW1wL3BnX2JhY2t1cF9hcmNoaXZlci5jIHwgMjggKysrKysrKysrKysrKysrKysrKysrKysr Ky0tLQoxIGZpbGUgY2hhbmdlZCwgMjUgaW5zZXJ0aW9ucygrKSwgMyBkZWxldGlvbnMoLSkKCg== --===============5094351276684444749==--