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 1vzXNI-0015zM-0g for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2026 09:58:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vzXNG-00FRtS-0r for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2026 09:58:06 +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 1vzXNF-00FRtJ-2m for pgsql-hackers@lists.postgresql.org; Mon, 09 Mar 2026 09:58:06 +0000 Received: from mail-northcentralusazolkn19013094.outbound.protection.outlook.com ([52.103.20.94] helo=CH4PR04CU002.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 1vzXND-00000001mFU-47bd for pgsql-hackers@postgresql.org; Mon, 09 Mar 2026 09:58:06 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=VPna3vIzqtDT1Ly6Utxoo3ytVVaoFrOCNqsRrHBmzZde8YKh2zyUe9T2W/Ep9xgSbbK/axcyPlJVyhMvwSCa4/X/oP8o6hxBd84rtNr9jT823k8Wl4iE5mGxBp0w40r5BvgvXSXtKI0g9Kh4SC2tNrKqg9x1FYzL5MAwNdL0W4ZQYG92HNGihwo+hZtPBF6pWdcUpvm/4MaO4Z6d6KrO8joTnrF3qeHliuRI9AZarbAGkiFNd+6sH6OZWl7idTnY2lO0Kt2gg9Xh3TSQUaeGtKIgYTiq2XqUTdJcWuCZjJ8qKNkCrJ4Zstsykqm2J0jkLrjMK6qPf6chSdZmuaKckg== 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=UwzWsjp71c+5cKUBzbnvkVvsWjUUNpo1klnnrlURYPc=; b=EBsuz/I856iEZSEXv4+iSd7J0Mkq6yNvViSki08VB317ajlrl+kEgHfOh+K8iYEMNYfFdgb/DiSIfO4NbOB/ed7snZCrAT+67n/IvOTzDZwQnt+24VOZtzUeaADDjqLkNKoHM76i+Ixg5F/IFC+sIXKvbdlJQYS8Gx18lP6soikcAxflMWkGF8f1NmW3MusTTv2B9QKe2DpaOLoxSfqICwtdtuT6xrMCAvp8kKFpusenlVr0JZcp82mAhQMF8+1YHC1JYpEAgh7qzcXloTt6P8vsfCJKoTBYld9tDf2PfmZY29DPnStg74lJfYtKC8ytbF7NJySi/0m3RR2BPlnRRQ== 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=UwzWsjp71c+5cKUBzbnvkVvsWjUUNpo1klnnrlURYPc=; b=NvxgEsuW0HFC5GpPJlN2Zhcq8cS18Twr7DGoroBUZa+0sk5MMpjjthQ0JUdasIUek4tt6E3PK9LIKbQUMmqTAvO86bJo3k/POgUyVezAsTqlh3xnvrGca8Gfl1mP12wYtEAn1ZU5ijpa6j4eKmKnq+VwNXV2C2NQ0jxWZocIqcl0dokGpqrLCZ9wQq7+8rRoGQjSmAAY7MN4H0C1Eha1UFZXEXOR5+DliPWRUuVALr3XMGvzaxZkmTqC4qQ8pmAGja41HQq24PNwI+gvJKGWkkR488V9sCGPWcHJtcQDqmMbNg+U7wggHMjB9nwlUm1ahdiU+esTxa/otoGbl74zgw== Received: from PH0PR08MB7020.namprd08.prod.outlook.com (2603:10b6:510:74::15) by CH3PR08MB8609.namprd08.prod.outlook.com (2603:10b6:610:154::17) 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 09:57:57 +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.9678.023; Mon, 9 Mar 2026 09:57:57 +0000 From: Boris Mironov To: "Hayato Kuroda (Fujitsu)" , 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/4IAEH5EogAAqmtCAAB2CYw== Date: Mon, 9 Mar 2026 09:57:57 +0000 Message-ID: References: <9e53df419ab74409a5a4a77f26740c89@localhost.localdomain> <14424e6549e84cb4ac51b0f80aa90348@localhost.localdomain> In-Reply-To: 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_|CH3PR08MB8609:EE_ x-ms-office365-filtering-correlation-id: 3fe83aa2-df09-4806-5b7c-08de7dc25724 x-microsoft-antispam: BCL:0;ARA:14566002|8060799015|15030799006|15080799012|31061999003|12121999013|37011999003|25031999004|51005399006|8062599012|461199028|19110799012|40105399003|3412199025|440099028|102099032; x-microsoft-antispam-message-info: =?iso-8859-1?Q?iuzb8GSCi91BGo2LKiXMIFIdZ//UAYh8sOQcg6K25SJQ4gYg4V/M7K9LrE?= =?iso-8859-1?Q?8E48t+5gNdCCY1POxt8wbII3WR0mf1+mnaZZvujsydudtP+VmudExALuYB?= =?iso-8859-1?Q?kDyYgF5NU8Edj03VXl1O98fOs9qDBiu5+7eytIT8JsAuG3Si9lMjOi9kE8?= =?iso-8859-1?Q?6dxHFxnVDdqwa5EJL97WYWLCn/KS5Q0g2nMEoq7IKZaIyrVsXPhFU1Ae5Q?= =?iso-8859-1?Q?qB/vRrMb8HldpZiRHoXDSY/L7523TajQYBZ/CM5RwTGrZ0dhUBV3be3SQr?= =?iso-8859-1?Q?nOoca59UfYVQdTSflG6xvy7MNnrBzzZrBzZRAyZRoEmTuzBkZxYM19I92f?= =?iso-8859-1?Q?5+F/uPXMRFJCjKP3p9x5xZ66tXyGVRCXZyMSSnwAp7Eu5IKMvqaSMqPpXs?= =?iso-8859-1?Q?wlMwPF1AO0Ae7SWVrOB28MCwtIPOaSbmgc2BQ6+Kky9kU/DcLiRiatDOjV?= =?iso-8859-1?Q?sn2GD24L5x3fg4J8XU0ZeuD03zMz0p9Fcp1UJztf+ITSYQyQEkS4rtwhFK?= =?iso-8859-1?Q?w08fx5HziFvJblF51ECBDT5Eyuemvb4s3oA9FhZrv9iw1TxliJP+IBSUTc?= =?iso-8859-1?Q?bRgWO1AQPSrqaZ4mJqK4/NHOj+lTQVf8WVc+ikFaEC8EsFQwnmYBNJ0gIn?= =?iso-8859-1?Q?UOWbbeDFaKDvGQUnq516/OOwmDfHhHAMe+jtq1M/3naAPPC2bgXTBI5cfj?= =?iso-8859-1?Q?U9dBaQefNdAnNNRlKiAIJOZZ7wFw/k8yHHUd7HkxLN+ugmpMEHiM6sTN2t?= =?iso-8859-1?Q?C8mXkwhsoSa2GQ94OZ/lu2gqrQqNkcPf2FPX0OgoAGf7VtX0Dch4w16pdj?= =?iso-8859-1?Q?26aPbelOJfwgCPCFFQLwKP76Ur1ddWsmlfAOXYNcb6lUeAbu6osZGZjYhk?= =?iso-8859-1?Q?Q3ZUta+2hYXzbDhx8S/q1pauA58frlMkfrONHDOQQMMyYywUH6FR4eGFS9?= =?iso-8859-1?Q?4pYaHXWnmyuLVXcMho8o5TL92NxUCQzVrxNYjSuh4lQ1vI9hwgeP90JDzx?= =?iso-8859-1?Q?xyGBW94eMgEydQQ26xhQK6HVQfdRQBRel3O0nR4ig3B7+fSYJcUaAkRmqC?= =?iso-8859-1?Q?vsRiucfXe+aJmrs/VwXK+cI=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?QUqogkY6gIj4G4FugcYQco9EDJCR3C/erAdoXF8mwklG00+eMgT3e5ocv/?= =?iso-8859-1?Q?Qr5VL150h5On/OJlNr4JHZ4BcCQDQUrCvgraTrKdr0fHuzXqfswrZF+iuy?= =?iso-8859-1?Q?jyMNEefgm916nSzDaT1sq5J1JqioyInDtzMjGMcdruXks4iTgTEoHNwmYC?= =?iso-8859-1?Q?hfxsglfmFIwz6BC7ScIXnRfIIk65W0TIxRcyLzg8H1Z6zxlrK5T83US1Ho?= =?iso-8859-1?Q?5pRfRax6udC354gX7qNRdVIW+SA/Q9J1EpaN8MMr28Skjffi+pSKoBayl2?= =?iso-8859-1?Q?duNJQsLGoga1/sq+s+gAA5ct9plKx/037kJqQiFxrjgd714CAggXqVOf5t?= =?iso-8859-1?Q?PvKsOctaOxVzeF+EcVl996suuPEmF8G/aSlJhrRLw5YstvqofA/0m9t93W?= =?iso-8859-1?Q?UL8rIafDrfMKUNXrIM3vsVR/Cisro3LS7P5Mw+hAEl44svJvXF5+6Np92b?= =?iso-8859-1?Q?Pkjr4vYgJtSAX9Q5wU1JF42UOcS1jx8ksYSGdxxEVDGq3KgyOq64pUk1Md?= =?iso-8859-1?Q?qVmXz20sO+7SyBFEzEq8+/8hhFnI3r4ccdSsqHuaWLEk9ZUA9JdLZTWZOT?= =?iso-8859-1?Q?QiSJTLBeVhu2FN/HXqUxnKneFOm8jrMvKnSFYDuLzeC3GelwwSi/4q/lyb?= =?iso-8859-1?Q?pIzVgRmAgrUzAu8uj19FOCtqqfR1VXeZXsJCvr9jx7bKAdmAOj5GgrVUSa?= =?iso-8859-1?Q?vDZDyOmNRLrqfTTY/2DtmMuCCJQxjrc9wMfY3KqIv8RDTBA9NtC85ak7SI?= =?iso-8859-1?Q?9KsBO3sVnCAAUOJxCslCsv6KwOG9JMQQMlKEtP2bdr9xRtY0j2Ol7VyN1U?= =?iso-8859-1?Q?DAOJu7eJA9acumTE14TyDNbHJNTtXahusjoavC+ofk6o/N8AWCOeU9BG3I?= =?iso-8859-1?Q?FRgNKzVvYByoKSkmnXc5z/eaEcIs7y7CGFqi0Il49w5xLZPebYw3xgWbc9?= =?iso-8859-1?Q?uvqo5tIaDph+ME5GCrVrbM0SArot5x4zEN+1ouyVYjACvh8W4HKCNX+/ej?= =?iso-8859-1?Q?tnS454gJoSHSN731e+6uqIIUBIbXzJmJYyRd8erdoQR0z+EITy/G/cCqEW?= =?iso-8859-1?Q?gQnvIfD3bIBzOOd9uC0gRM5+/B5vPKQuR+MaGiismgx50gEyBLU7/C1Tlg?= =?iso-8859-1?Q?7X4aRo2FmUIHNy87uU66MgOUQBpL7BKSQ9QSYwCMOmZVE4lTTW7/+cokwH?= =?iso-8859-1?Q?xszUpV8z2OtGEeM3GyX0IxdsPlKJKlEMzek30KafiOqw/Yqjl/c+B3PU8W?= =?iso-8859-1?Q?jelsoERAQKlJdlnayHZCtLytIja7TmpbVYYtwFrTyi7Oomd2EBmmDP7YpG?= =?iso-8859-1?Q?rNFd6KLDu/NYgMhKnyPi1lSvqozXofVYpeOcqprEcAg0YNbIeUOp6qfWXH?= =?iso-8859-1?Q?4OoQr0semh1FrGn/oKBuLwl23BDWAQE7xmVhE1EOOcTuRkYzJKH9In77Cb?= =?iso-8859-1?Q?ozgTOheNVDOg45YSU4AFmk4feipjc0aBAQ5kDg=3D=3D?= Content-Type: multipart/alternative; boundary="_000_PH0PR08MB7020F6EA8877834CCDD5FABB8879APH0PR08MB7020namp_" 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: 3fe83aa2-df09-4806-5b7c-08de7dc25724 X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Mar 2026 09:57:57.1865 (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: CH3PR08MB8609 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PH0PR08MB7020F6EA8877834CCDD5FABB8879APH0PR08MB7020namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Hayato, > There is a similar idea which parallelize the initialization. Not sure, i= s there > an interactions or comparison between them? Your patch seems to divide a > transaction into several parts but everything is done by the single threa= d, > whereas proposed in [1] is to dispatch to other threads. You're absolutely right. Mircea (author of multithread patch #6242 [1]) con= tacted me with a question if our patches could be merged. At that point in time none of our patches had reviewers and sheer size of each one of them was qu= ite big (~500 lines of new code). Therefore we decided to leave our patches as a separate commits and see what community will say. It's quite clear that there is certain synergy between them and perhaps it = would make perfect sense to introduce them together in same release of PostgreSQL= . I'm not familiar with intricate details of process that takes place after C= ommitFest, especially if several reviewed commits in "Ready to go" status touch same area of the product. I believe that my patch shouldn't require too many changes in order to be m= erged with Mircea's one since core logic to initialize set of rows in three main = tables for one particular "scale" is already in place. Thank you for your interest in my commit and Best regards, Boris --_000_PH0PR08MB7020F6EA8877834CCDD5FABB8879APH0PR08MB7020namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Hayato,

> There is a similar idea which paralle= lize the initialization. Not sure, is there
> an interactions or comparison between them? Your patch seems to divide= a
> transaction into several parts but everything is done by the single th= read,
> whereas proposed in [1] is to dispatch to other threads.

You're absolutely right. Mircea (author of multithread patch #6242 [1]) con= tacted
me with a question if our patches could be merged. At that point in time
none of our patches had reviewers and sheer size of each one of them was qu= ite
big (~500 lines of new code). Therefore we decided to leave our patches
as a separate commits and see what community will say.

It's quite clear that there is certain synergy between them and perhaps it = would
make perfect sense to introduce them together in same release of PostgreSQL= .

I'm not familiar with intricate details of process that takes place after C= ommitFest,
especially if several reviewed commits in "Ready to go" status to= uch same
area of the product.

I believe that my patch shouldn't require too many changes in order to= be merged
with Mircea's one since core logic to initialize set of rows in three main = tables
for one particular "scale" is already in place.


Thank you for your interest in my commit and
Best regards,

Boris
--_000_PH0PR08MB7020F6EA8877834CCDD5FABB8879APH0PR08MB7020namp_--