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 1w0h1M-00282L-1m for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Mar 2026 14:28:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0h1K-00FLMf-2n for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Mar 2026 14:28:15 +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.96) (envelope-from ) id 1w0h1K-00FLMW-1Z for pgsql-hackers@lists.postgresql.org; Thu, 12 Mar 2026 14:28:15 +0000 Received: from mail-eastus2azolkn19010005.outbound.protection.outlook.com ([52.103.12.5] helo=BN1PR04CU002.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w0h1I-00000002JMv-3A0Y for pgsql-hackers@postgresql.org; Thu, 12 Mar 2026 14:28:14 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=Z8xaQl2t2qS+esd+bh+NF5nxqH+xLn3TK+QTuTnMbJjsslEvM10ZPYXOsKJtCXZK5pEV691QEbtcSmjodXmIHRQ18eUVQGONr243phOhZhVnIrX39lOCdFJYiXkC0PmfSFmUHnd8TL2lfpMPsjHB4A7u4oKu8tXxdRpZ3cXE4r7gvZmOYYWut/s3XoeBo3nmqZtvExc6ePRdM8BuFhQiFNxOwnb0E8CmqRdl+Ga9YPpAJb+3USq3Z64mgzrdVUzKwCjCtvTzGE7+WTrTJkUUIepKMb5VHCt0rMOr73EKIVqTZFKGnH7yJNBSn73vNyvL4fLSYkTnWdpP6HX+ojCWDA== 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=msjkPfSIXnhSOV+SAzvMJbZxOO/HaiKxjhzBFGa75Ew=; b=HRo46ZyyhPfX9sBku0DiDjKgRhoRVCOnpAGfUcrGbvLx/nI9ZEU7F8tw28taCc7pliJG7KEc47wD7ImZW0mHACF22np0zGKRxFXdDrpMfAMTdsLC252T+/r0ilJk0dpN4A04DAzdTzvnLBiIEuj4twOUg0V08/7Zqa8loPMOqDQ3Do/DTUabgh4qWI6xf4BPYQm1D9ujIVoHFjG1xicX/UzcajfBEJ3IPVer3SM+FdgKJQqBh9YVhXaoECkxmoby5xcxM3LsJBjhNyyIJz8M8ZK0zPZI5HZmwsEr7+fTyl6X0MrKJxueG6ZeHEcWSCfBN2p6SR6Mqd9ExCenzYUOdg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=msjkPfSIXnhSOV+SAzvMJbZxOO/HaiKxjhzBFGa75Ew=; b=GEUHNsVT/BTJz4iJmLBOtA73b8XvCAhSQrI/wngbK9RVgsJjKSTmLJol04vTk09t/ugjnPX99VdKGvhzhC4cv+Z+ctRKw7ukGedwk8hoZi15G8d0zS5NP5rTbNI+scBeD30zMCAq/IwrddyjeoHGn8VEnnDc8r1i9EaGAf+NxQGtqbnoFf+OK57TvUCuwjMgKTytrsZzssEuS8ajbKm32KIDyjMl3BN1ngTgG8N2MKOh3ND2KKDvIUXdEpfPa29hPYkq2Y6651rvOk74hauE9DutojUNJLJWKnuTSAOnjPI5x7EtNw9leAr+GhIJ4he5M9H3coogeWRsOy21H/9dyw== Received: from PH0PR08MB7020.namprd08.prod.outlook.com (2603:10b6:510:74::15) by LV3PR08MB9608.namprd08.prod.outlook.com (2603:10b6:408:21f::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9700.15; Thu, 12 Mar 2026 14:28:09 +0000 Received: from PH0PR08MB7020.namprd08.prod.outlook.com ([fe80::129a:a42a:445c:3273]) by PH0PR08MB7020.namprd08.prod.outlook.com ([fe80::129a:a42a:445c:3273%4]) with mapi id 15.20.9700.010; Thu, 12 Mar 2026 14:28:07 +0000 From: Boris Mironov To: Madyshev Egor , "Hayato Kuroda (Fujitsu)" , "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/4IAEH5EogAAqmtCAAB2CY4AB1oUwgAFzVZaAAZkc4IAAJc6i Date: Thu, 12 Mar 2026 14:28:07 +0000 Message-ID: References: <408cd5617d954ba1aca99f26b4693fa2@localhost.localdomain> <4a3bfa370a7d48d1965b12572a0de0e5@localhost.localdomain> In-Reply-To: <4a3bfa370a7d48d1965b12572a0de0e5@localhost.localdomain> Accept-Language: en-CA, en-US Content-Language: en-CA X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PH0PR08MB7020:EE_|LV3PR08MB9608:EE_ x-ms-office365-filtering-correlation-id: 2a925cf9-3e39-4236-2e23-08de80439432 x-microsoft-antispam: BCL:0;ARA:14566002|37011999003|51005399006|25031999004|19110799012|461199028|8060799015|15080799012|15030799006|8062599012|31061999003|40105399003|440099028|3412199025|102099032; x-microsoft-antispam-message-info: =?iso-8859-1?Q?X5s6l46bedSau7t0MUaZjbTbiPcbdEF7jDm1ky//lqHLHHywx5H6XtCSnR?= =?iso-8859-1?Q?AGqo/I40aU7x1oS2GZC68crYx7lGCyiuWEm4DBUZRXPm5yo/1NQB+8YG2i?= =?iso-8859-1?Q?gEbrxzTLhaUNzr6QSv9i9YT0bwcGeD/49Xy9IGiC8PppDcGOyXXTwli1KA?= =?iso-8859-1?Q?1Y/WSfMfRrlFmC2te15XPv3yVWr6XpHNOnwgmx4+CjRbHnq1Aj2KyTCXm/?= =?iso-8859-1?Q?EgpLQcx4o878ROng2AYG2YrzELE5/Nd9qFs3HZL6o7cC+GmTyrGnunDoXB?= =?iso-8859-1?Q?2gqKDFfq6E+9Tcv8lAA5MtU12Qlst+s6aqPsvrztIbOfJeSe2PuTn4/oQH?= =?iso-8859-1?Q?kNkDBekJrAgEQFY9iu9kEtYyCnW0utAG3yZQzGIX83rTZAPNE/9Im1JuVX?= =?iso-8859-1?Q?iYQeV6+6dWVFBYuym/N9gOR5UI6QYX7rjJlMwPuA/X95IZj2F07akcjYBS?= =?iso-8859-1?Q?MtqM3aRFYe5HpGn2hJrHnbmL6N1KH4zrYgUwFyyW5wJCJv+KeYE4MZMFHN?= =?iso-8859-1?Q?Lwi9IonSlGPy3Lh/tbfF31R4hYxoee7y/9JF0w0DOx7+eQ2LWd7OKu2BYp?= =?iso-8859-1?Q?Y8G1MqdDzrTgHLSQx9XxS5oyHgYBZNNUNcPHf4vfDl1wpBPkHXnDzc5loj?= =?iso-8859-1?Q?BNxWgWC9aAC+V6flYJjbK0Cp9vmAIljequb1nG2NvpRrpt3xDnmo/fU3Km?= =?iso-8859-1?Q?8ueqzuzm4mcXH7n6J8sLzuhkCNOCqtl9ncdWpFsibYvYpKxPiUkeieYOHH?= =?iso-8859-1?Q?7OiyGVlA+zGFD+9wtUWYvo3LAEaSPWrrMAr/Zo+wMeupHNB4jvQc/Q8TK8?= =?iso-8859-1?Q?wCViLiFTK9a/5o0cRZgOAyaJAl/TUdt6WBht9lXGG4awS9BWkUQkQmEtPE?= =?iso-8859-1?Q?zqTvS1dJoS4UWf5BbqR9NAp7OOaguf+6FxpqHU6/5dtUjprRVmf+QcqR5n?= =?iso-8859-1?Q?x3XYp4fYKfe1+3avEWDAlOPJWubf+wTnnahy0rasu11VxJPmf52hdbmvGF?= =?iso-8859-1?Q?1NfYuF9IWjCe95zDX1UcuMmrqsekxl6MzfJlz5?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?aVg12POXIqGw0t7drerA+KDgvYtl5uU/EDeVMuaLhI8Hj+qnPDQaDECPRu?= =?iso-8859-1?Q?oQiF2VzQVcX06XrIe8coIFuiM8Yx/xAqgvUjT9/aTYUnG64DXhVMuIc0XM?= =?iso-8859-1?Q?DrAq3wHsxT/2ks8sUDwntrsb8b8vNi0JPtbr/uS8JofNDwhbSonVqI863x?= =?iso-8859-1?Q?8OlvOkqChkAVOYuHxLM37rAAJb+cDKet+dsf7rVJffJzZriklx2FUJsarw?= =?iso-8859-1?Q?6S5uCzZSGaLWelivmmI8rpQ74NQiPrnwnIqJDemagTgfwbjxChh/RBhE7W?= =?iso-8859-1?Q?MvDxeL68EW8gbqgumR8W6shLpXUKBeogRsicKOlBo67ZTtUwf/lmN0jMss?= =?iso-8859-1?Q?LQnpdOxGw+7hp9NeplXI6zZkWGWuWmQ7iiYwJIbJ2duKkbvWjBuuFooMql?= =?iso-8859-1?Q?pnIzE69cL1AT+2on9L9nlrs6fFVirwRBISyv6Lj/vMPmDTOw81pA0GoOMF?= =?iso-8859-1?Q?Gr14rEr7BFs5IUqPJeqyor0U9KxlSEHEhvE1qKCwNXuesiLM2TO5YpgLQR?= =?iso-8859-1?Q?fDlW3JpzHMFkRXyCjTtujhq4cMXiA4N7TXS1Cut0oB1hlqaUbwIyl+Cnep?= =?iso-8859-1?Q?w3HVB3iBKSa23QLokPhtux0eBGOSUak5Z18vNLa+NU7y9JU3n8A3QW2d+G?= =?iso-8859-1?Q?eABrCtIO8gzQZUNXW/fEL5YWkG95/myguBQrnLdq+8vyCTDwn60MR+WS9w?= =?iso-8859-1?Q?hj1ULmOnqI9VhdlW7Shtc6RJiPyYesbWquTxXw4GhjZX1y2ACgWZEfUIWu?= =?iso-8859-1?Q?jbHtjz1vfjDcOw4P5ENGGx57YnBIrWMyjHjSiMC1juVXgytANUY/OV2He4?= =?iso-8859-1?Q?+zz2FpXcUsAInjuObbhNthFRo40Iq91da2OoJwuSSUTRqzrPsZn0kCIjYJ?= =?iso-8859-1?Q?IyhDUdRp2JTolRoWVfsUg6zkYIxbzTqWrO7PinzflSpcAmgioGb+fv82AB?= =?iso-8859-1?Q?Nb8c/ajZYQccewf+szCPEb5XhTGbR5yHS59a/SAIo4++VVb/pnkCNiq1wi?= =?iso-8859-1?Q?7tDLfr6QOAPGXXvMMwzA2rnNT7Gr+dxwuEDl6w907UN9XIvx2RuXCk2Nda?= =?iso-8859-1?Q?Z9xqh+dk29wru2StnU2nGfpFSRQ9BcOdsy1S0k1CgSs39gQSAq0WCclj5V?= =?iso-8859-1?Q?axfpVfywXea7iMPzkvgDJNgBWbLaN6Ha+AQ2p5FrI9BtTPN4quUPsSQMWT?= =?iso-8859-1?Q?BmD4K3l3bsHYGRbxSxPIIuJIfRKhsMCH6zP9T2RlK1IRtrm9fWraq9Vqr3?= =?iso-8859-1?Q?9wRD7NIKX6Ngz/vbMGQI/foUjRmbd3iNZaXeeeAhrARMbv1rI0paooCcm5?= =?iso-8859-1?Q?kq11Xk0fxHMVgsGN6VZo3lh0O7aW2YQAIT8YqIcBU4u0f/4PuQhk8sRN/6?= =?iso-8859-1?Q?UkkBe3kV+Qja3qycYF7G7bmEc7CwJ+caVRjbbCMfTPKNZNcEusXBtM2F1v?= =?iso-8859-1?Q?CHd0H6JrhRrAbVkvaJuZJmpIqO6cxrsCrnAWDQ=3D=3D?= Content-Type: multipart/alternative; boundary="_000_PH0PR08MB7020956FB86755AD6B4E2DCF8844APH0PR08MB7020namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PH0PR08MB7020.namprd08.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 2a925cf9-3e39-4236-2e23-08de80439432 X-MS-Exchange-CrossTenant-originalarrivaltime: 12 Mar 2026 14:28:07.0213 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: LV3PR08MB9608 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PH0PR08MB7020956FB86755AD6B4E2DCF8844APH0PR08MB7020namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Egor, Thank you very much for your time reviewing this patch and guiding through some of its inefficiencies. Yahoo! Best regards, Boris --_000_PH0PR08MB7020956FB86755AD6B4E2DCF8844APH0PR08MB7020namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Egor,

Thank you very much for your time reviewing this patch
and guiding through some of its inefficiencies.

Yahoo!

Best regards,
Boris
--_000_PH0PR08MB7020956FB86755AD6B4E2DCF8844APH0PR08MB7020namp_--