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.96) (envelope-from ) id 1vzVST-00146u-2F for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2026 07:55:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vzVSS-00Epz5-0A for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2026 07:55:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzVSR-00Epyx-25 for pgsql-hackers@lists.postgresql.org; Mon, 09 Mar 2026 07:55:20 +0000 Received: from mail-japanwestazlp170100003.outbound.protection.outlook.com ([2a01:111:f403:c407::3] helo=OS0P286CU011.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vzVSQ-00000001FfM-0NBG for pgsql-hackers@postgresql.org; Mon, 09 Mar 2026 07:55:19 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=YbjloNj2w06Q6Y/bm9J5+TRIMqNC+MCCEHDotvq3UW7EaTGFh9cp2BREDdF/jRHNWwAr+9Fp61P4QDHY478qHRTxM10GrfopGKsPq9vIubi6Z/OfIdKxoma6tyXk4CtStDJLBvKfql6B64JNESfeESGhj0HvvqyAVshUh5eYCnEZ+CQWHVW+EV3nE6oVRFlppdxrZo/4R6b0pOZRgJ9/q1Oea7czxqXqM1DtTN9HmTHL1T8RkuvaoCxX4UMWJVqQFBKqbRcmTRYxX+6Gb8ezSv9ctoS3FvNpFWOWQ1A6JXFUF2Bo0l6hBfulMn2uMs2/iyXnOsSCVQ426rbLkJ5L4Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=tAmV+QmuUEppQDg8Zlkpj1Efyl88AQ5QkspOUzRo/10=; b=PdZ2jXy/2fjAkhOnWrEJEYAI3qjY9r5djP2ackmSfsVD7TU3dBOe0C6wXd9sIZs80Pj8oZ+Oe9ZU/utrjk/OfLInBtnhrSmW/vchVtKr/99KQK2DNts0GNGMMGnx6jeUzLGSV78TAy8UVs3pwzO3fxsFU3r3sLGC6+06LCRySslPbDIPTv5cvkCOj4Bo9xbB44B0qrTQ4GzhDZCR7QXGW6YLB186YAW+4+oljZ1a8MpLDWblqkyc3ugCYkyHXjsUr4dFU7bnb18UI1KD80EZ8kMLM0icrQIbc6rucTsgftukHba8IOxOVoRTFLYzTDUOu5SQhUoAzpvND51ilo3sQg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=tAmV+QmuUEppQDg8Zlkpj1Efyl88AQ5QkspOUzRo/10=; b=Si3o1ERoUmLgZYe1MJ5VPuf02eD1D8cx1VwoVIZt8/YXo2LDR3JrUV8Kl1UITSX7eTWyqrOd/ywox85Gq0SxdPOFBeKLqruJKE5Hz2AIiN9iJZ9ifPWBYkIBa7vSeASukCxMiKlYimQxM+U0yuWJQJWwK/z1E8864AoovONKeEVkmPfHSMeMrjNQ481VUgRRuob5C/ujj4mIBKoZumLkXsVe+MRFd+E410T2LMQT9bh7y4C/jce/FErnQELalr9xVoFldMl5Mgtgaqm7nDSirOm7AJz3OGb4e0ZffglnARX0Sw9w1K4OnXGzkoB2xCz2Qbli46PaOvTpDjz2yxraiQ== Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com (2603:1096:604:2e5::8) by TYVPR01MB11097.jpnprd01.prod.outlook.com (2603:1096:400:36b::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9678.24; Mon, 9 Mar 2026 07:55:12 +0000 Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893]) by OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893%5]) with mapi id 15.20.9678.024; Mon, 9 Mar 2026 07:55:12 +0000 From: "Hayato Kuroda (Fujitsu)" To: 'Boris Mironov' , Madyshev Egor , "pgsql-hackers@postgresql.org" Subject: RE: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) Thread-Topic: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) Thread-Index: AQHcUwuRPlzLCtdZw06GAdoL15fmHbTwZ0aAgAGpzjGAACRkgIAAEcrGgAQQLgCAAG6d+YAGXmPMgAFzjL6AAV1tS4BpseD8gAEgG5GAAGN+EIAAFWg0gArDj2mAAAeBfoAE2r6AgBXReIKACYuvB4ABsvMggADncVaAAHeCloAEeaRAgAAKHACAAGj/4IAEH5EogAAqmtA= Date: Mon, 9 Mar 2026 07:55:12 +0000 Message-ID: References: <9e53df419ab74409a5a4a77f26740c89@localhost.localdomain> <14424e6549e84cb4ac51b0f80aa90348@localhost.localdomain> In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9ZmRmN2EzMTMtOGVjNS00YzA2LTk1NjAtZDNmOTA3YjZl?= =?utf-8?B?ODFhO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX0NvbnRlbnRCaXRzPTA7TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5?= =?utf-8?B?LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfRW5hYmxlZD10cnVlO01TSVBfTGFi?= =?utf-8?B?ZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX01ldGhv?= =?utf-8?B?ZD1TdGFuZGFyZDtNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9OYW1lPUZVSklUU1UtUkVTVFJJQ1RFROKAiztNU0lQ?= =?utf-8?B?X0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0ZmVjZTA1MF9T?= =?utf-8?B?ZXREYXRlPTIwMjYtMDMtMDlUMDc6NDg6MDlaO01TSVBfTGFiZWxfYTcyOTVj?= =?utf-8?B?YzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?= =?utf-8?B?ZC04MWUxLTQ4NTgtYTlkOC03MzZlMjY3ZmQ0Yzc7TVNJUF9MYWJlbF9hNzI5?= =?utf-8?B?NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfVGFnPTEwLCAzLCAw?= =?utf-8?Q?,_1;?= authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OS9PR01MB12149:EE_|TYVPR01MB11097:EE_ x-ms-office365-filtering-correlation-id: 5b9a0ecf-67e9-4d81-e2ad-08de7db13181 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|1580799027|38070700021; x-microsoft-antispam-message-info: EUFquOfF5KnnrwRKM5Si9ADX0kUj4ToIzABbj/MACpynyF0DkeWFx7JYg0yPokvY0H4OvnCy+rKTqpnCX6LU0Pz1/qbRx23ks3nX0dp6nLtOaFrcSupfK78Pm9YKPzet1iOfMMiZbHL6b+9rBeOgDYF1Kf7Y1hY229LSRK/wpP4FRWQXF+gFsDr2/OTaX12J/CHBR+Iu5wQyULk0ljE4xsSApO0AUdrz4N7BRAAfzl1JeUAFfxuLHgNk+KOQP7Teeo0U0dn9ae3pV41pgaYluFPRMLHb1MJGOwBUG1Miz+hLNzkSx3WofLv575hZrEi+UM+D+pwmhIzpPB5NtWgxrFzgb1j1v+b37imf+NYYBvypha9JL5zjewzr275fLA5pXiMPbyILjgQ3FidLj+XvIR/QtMTs/itK7lH+jAnZaz9wxLASqt+2Yk4Txd5MHftmG6KX8qwgqIZmGWxVTFU2TwmzHqX3cZtiF94SvUstzTCtPMLTRvWfGI8t3lxBsDQ/QdtAInai8AWKZ+j0FVCQsoe46/7OiHNZ8bcbkG+TInClEznXOVVhkiCeefPV7CKitabDkDxq8NtkE8WZWh57ayVQtA9pHbKCR6oIxdA0dS5UDPeQtU/m7M7TgC/RkUBsT3vIAAhJmiuVsLBoKhRuGcuE192wgIIjvIMDX4zJs1z57FzIF5VNW6BVy/5n0U9O/U3Prc5BDZRwANxK9KsC9Sho5q6AWEnwQYqRmSN2vPHiCt/anfanMZNQ4eVGafJZvF2uyHboLmt3C68AZ9zSZA== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS9PR01MB12149.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(1580799027)(38070700021);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?eE1vUEREK0JDcWdGK2RZUGpiUzRDK3lZT2ROYzExbzdaaEh6Mk1NOFBMWWxL?= =?utf-8?B?aE1BVU9weU1raTY2SmpPOEg2NzEvSlhiZHJLTmlTK2FvYUZ5Wmhsb21XUjdr?= =?utf-8?B?eEdyanU3SDlzMkxic3MzRlZLWFFkSDdOK0x3WWFYNVQ0NTB1S1lYZEQyZ1lU?= =?utf-8?B?TWM3TGZhWjY5dlBtajJSTE1FY1ZqUW5xMExOQ24vVnkrN0EwSGJnTnlzSXkx?= =?utf-8?B?MExIdWxZeFVKMzhORkI5bDU2RnAzRVM5a1VUdStqNmpuMjE0WlZOclJsaUVW?= =?utf-8?B?NFlLbmNwL0FuQlV3N0N3Z0NDQktoaVowcllmZmxNVXdtSVFhdkdtMk1rc1F3?= =?utf-8?B?cm1LMzFRKzNpNEgrTXFHUGNpeGZLYmFjM0J3SitId05xNCtab0ZJa3FhZEZ1?= =?utf-8?B?eU1FaG45YTVySkxEUTY4OGhJOVB6bVF3QTdKSEFHV0hYamFtUGFsb2cwY0lK?= =?utf-8?B?T2ZsME5BU0dBWVUreE9UMldxeXJST21KYnc0VE85RTZ5R2RLd0RsY0xZZ2Na?= =?utf-8?B?ejZnLzJiYThoL0tWOUtMWTZQakhxQlVlaXFvZmJvWVA5RU0vMGQzQnRaN1lp?= =?utf-8?B?L0FUai9QaWJjaXJmZ1ZpRkxJMXoxLzNiK1lwdm1OclBQbUo2VVA3RDNXcXJY?= =?utf-8?B?VlRmd0tobGc1cDJtWVd1Ukt0NTRod3htU0RLdUxZeWZWT04yU01rRHFNbHJt?= =?utf-8?B?azdBbGw3MTY4V2syT2ozWnVYcHNWRUQ5c21EMEtweGxHOUZYOXlHNVo2K21x?= =?utf-8?B?dHZqRTl0REo3aFhWRHZoYm9UQll5OURGSmhROWJLOURHaERBM25sa1ZtaWZC?= =?utf-8?B?d09EdmNjczg5akRoSlpVNXNMdk9wbnM3U1VSb1FtSm94SVMrQmxreUk1dElS?= =?utf-8?B?MzYraWo2TDNnRDVXb0IzbU5GZThZVS9rTDU1NjJMbUxaUC9JajVvYzRRdnZw?= =?utf-8?B?TEoxQzFQM3l3NGlPR0FQZ0Q4a1NPUm1IWXhJdE5kUmJ2WFRKZ0xyNCt6Y0pn?= =?utf-8?B?S256TCtoV2J6eWl0MXk2Tk1WUmdQMlk2R3VWNkNoT0VZWWVYblRqdUljdEpi?= =?utf-8?B?cFNrMEorcllBbDdLam5jbmRCbkZhK2pabFdvdzFXQ0J3djJzcTBaQURhdmcy?= =?utf-8?B?WUJ2SXBoL0gyYTZDU2c0dUVzdDVCNThETjdQbU5WS3hrZWdZZ3hHcmNncGJT?= =?utf-8?B?dUxPcFlKdEtPWkpLWnE5TFcyVWUybFBOQ2YwNHp1bFRXK2lvenVDMWM0Umlz?= =?utf-8?B?c3Z5QzFXRUNPQ1pDbWdFVkdNMHRCZ2YxTGkrTjVzaXRRVWoyZ3JrRDljb0RR?= =?utf-8?B?WE1Ec0hLa3JBb3g1WnVyQmFWT2tFNHZ3cVlYQnpkUEVqQkpuK1RUaytLSXVm?= =?utf-8?B?TkdmVFdmekliWkZUUnZrREI5NFNvKzVmd1F3aUJYb3VXZUFIRzA4QmxOdlRs?= =?utf-8?B?VFVMbVUzWlQ3dmE1Qm80cmNDZWx3L0NaU1l4eFZpR244b0ZTVmpkdWU2bFFl?= =?utf-8?B?c1dPcUNOOUhZaFRWR1VpbElYRnZzckQyb3MyeDZEVFNmQmtDZ3BML3ZSdEQ5?= =?utf-8?B?Y1VOSEVtelIzdEVlYWlNeEhKQ0N4Rzd0c2tDazRKT0pFU0lGUHVXcXF1dmRW?= =?utf-8?B?V0xrdmhCSUkzWkxFaHZqYVlpM1RFOTUzQ0tRWlZHUzFTcEJSb0RuQVZaeFps?= =?utf-8?B?NHNzT2FDYmR3YUhzY0c5azhIbWtEemlHZGV5OEVueE53Si9jWksvOFVIVEMy?= =?utf-8?B?VlArVGQzTzk3ODNyZzB1TXE0aFg5b2dCM01NVTZxbXV0OEgxVEtIUUlJL3B0?= =?utf-8?B?QXJBcEoxWEM5b0FUV3B1K0V3TFEyamhVUEcrVDAzQTZ0UzRaV0NsSkFTSzEw?= =?utf-8?B?cVhSVVpIakoydXg1QS9URUpVYXFmOHpPQkZPK25lei8xTGdZenV6clNRM0U3?= =?utf-8?B?M2dHbFJUU3UvdUFmUFF3bHl4RDFYRGlFNTN3ZmFHME8ya2t4YVk5YnlqMmht?= =?utf-8?B?TUdiMFVUbE5ZUWZvYkFBRGlhWm9rVzNyU2R5TXdpL3VjL09CVjBMNkxTYkRp?= =?utf-8?B?VzFGOXplVmdabGd5OVo2bkRLYytaOSthdHh6WWtYQUREbHRKUEZnYnoxUWNt?= =?utf-8?B?bFpseFRiYjBpZllaU3V6bUx0aGdLV3dXTVRzMEJ2bkRqSldCY2ZtWHFaUStG?= =?utf-8?B?QzEvOURIZFMwYjlUN1diWnZ1U05ZVGJ0ZTlRVC9zdzZvZGMvYk42M2tZemRF?= =?utf-8?B?cHgrMHhxTHkxTlYrbWp1NUNzZTZmaklpYkRwU3Q0ZkdPV2FwZzE2MUpyZkoy?= =?utf-8?B?MjVVWDhiTUw2WXkxd01HTFY4VHJLbWRycGI4SzhVTkNTa3Nud3EyREZFb1Nk?= =?utf-8?Q?BcU8AFGZvq2kLi/8=3D?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: dY8L6c5VhduXlKCTFf/APSSjRO4zr8XLLxdTnlgEIdMenvjHWt+VrbZxMFqoZLSTjCovaMcQkskXIrbZkAUm7LB4pWUZ8QoA5pMGIeOTuYnv0tH8njUEokvo2pbFMuOc1JMBjVc6NuyASC70vvCLb8MmMRRLlVuz2fKDQxuSenzrGOtVXl+kpNABJ6TyhAM4LFSowHq6fVSsHWOOllg2IJ+mruUCMNeq7ITSEDiI1vvZXCFydj+CJhv3jw0XsaJN2O3GZFDu7nK5TAqmEq+rk38uts5rG+wqURGLZuAPUDiEDilaQOtRE8EVU1Tiyv91f6uWL2slTCftg5q42SNsmw== X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS9PR01MB12149.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 5b9a0ecf-67e9-4d81-e2ad-08de7db13181 X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Mar 2026 07:55:12.5883 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: ybEMJBTDtA2UB85GH4ZElclVR67kFwnKVA4AwxI14/oovS9tqollgJUfPIboDHjsJIgan2YMclWCfpLk9yqJ1Dwb6VBWZG+PWuGN3bmm/fc= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYVPR01MB11097 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBCb3JpcywNCg0KVGhlcmUgaXMgYSBzaW1pbGFyIGlkZWEgd2hpY2ggcGFyYWxsZWxpemUg dGhlIGluaXRpYWxpemF0aW9uLiBOb3Qgc3VyZSwgaXMgdGhlcmUNCmFuIGludGVyYWN0aW9ucyBv ciBjb21wYXJpc29uIGJldHdlZW4gdGhlbT8gWW91ciBwYXRjaCBzZWVtcyB0byBkaXZpZGUgYQ0K dHJhbnNhY3Rpb24gaW50byBzZXZlcmFsIHBhcnRzIGJ1dCBldmVyeXRoaW5nIGlzIGRvbmUgYnkg dGhlIHNpbmdsZSB0aHJlYWQsDQp3aGVyZWFzIHByb3Bvc2VkIGluIFsxXSBpcyB0byBkaXNwYXRj aCB0byBvdGhlciB0aHJlYWRzLg0KDQpbMV06IGh0dHBzOi8vY29tbWl0ZmVzdC5wb3N0Z3Jlc3Fs Lm9yZy9wYXRjaC82MjQyLw0KDQpCZXN0IHJlZ2FyZHMsDQpIYXlhdG8gS3Vyb2RhDQpGVUpJVFNV IExJTUlURUQNCg0K