public inbox for [email protected]
help / color / mirror / Atom feedFrom: Boris Mironov <[email protected]>
To: Hayato Kuroda (Fujitsu) <[email protected]>
To: Madyshev Egor <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)
Date: Mon, 9 Mar 2026 09:57:57 +0000
Message-ID: <PH0PR08MB7020F6EA8877834CCDD5FABB8879A@PH0PR08MB7020.namprd08.prod.outlook.com> (raw)
In-Reply-To: <OS9PR01MB121499E64344675A86179219CF579A@OS9PR01MB12149.jpnprd01.prod.outlook.com>
References: <DS0PR08MB9565D91414C65B3AC363825488CFA@DS0PR08MB9565.namprd08.prod.outlook.com>
<CAExHW5vtdtd5QnFobxOhbVeh5jk3_61zYRxLqCXEZpO3jOeFDg@mail.gmail.com>
<DS0PR08MB9565C0B8B45F7B8D78D89EA188CAA@DS0PR08MB9565.namprd08.prod.outlook.com>
<CAExHW5umH2K5w_5GRCWGrRHfceMjVn72hF=z_A7G+vReryx0uw@mail.gmail.com>
<DS0PR08MB956560D79EA051E98688F78088CAA@DS0PR08MB9565.namprd08.prod.outlook.com>
<CAExHW5vFMkBfv9zB3c5gxF=VLkR7dxM2a3pSFsNuz4JYqc8wRA@mail.gmail.com>
<PH0PR08MB7020CE2AE1B6937BD01B852F88C9A@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB702059D610C7D84594CD3BB388D5A@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB70201EC778A20A2BDC8A5F4A88D2A@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB7020802F14B1AC122AAB6F7588D3A@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB702075EB12438C2F9A32CD26889EA@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB70205C9C827602026F60FA07889FA@PH0PR08MB7020.namprd08.prod.outlook.com>
<[email protected]>
<PH0PR08MB70206B42F5A79A518B610815889FA@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB70204888D724794BA83EA6E58866A@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB70207B96C493E5777DB4D6428866A@PH0PR08MB7020.namprd08.prod.outlook.com>
<[email protected]>
<PH0PR08MB70208182284EBA18F64228798877A@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB702074674145021B680D9D6C8871A@PH0PR08MB7020.namprd08.prod.outlook.com>
<[email protected]>
<PH0PR08MB70202953137489C2DE455005887FA@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB702059923096E4BAA78FED02887FA@PH0PR08MB7020.namprd08.prod.outlook.com>
<[email protected]>
<[email protected]>
<PH0PR08MB70205AAE5B3E7305454A89C2887AA@PH0PR08MB7020.namprd08.prod.outlook.com>
<PH0PR08MB7020D4A335C27DC7F07C28C38879A@PH0PR08MB7020.namprd08.prod.outlook.com>
<OS9PR01MB121499E64344675A86179219CF579A@OS9PR01MB12149.jpnprd01.prod.outlook.com>
Dear Hayato,
> There is a similar idea which parallelize 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 thread,
> whereas proposed in [1] is to dispatch to other threads.
You're absolutely right. Mircea (author of multithread patch #6242 [1]) contacted
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 quite
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 CommitFest,
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 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
view thread (21+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)
In-Reply-To: <PH0PR08MB7020F6EA8877834CCDD5FABB8879A@PH0PR08MB7020.namprd08.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox