Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)

From: Boris Mironov <boris_mironov(at)outlook(dot)com>
To: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, Madyshev Egor <E(dot)Madyshev(at)ftdata(dot)ru>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)
Date: 2026-03-09 09:57:57
Message-ID: PH0PR08MB7020F6EA8877834CCDD5FABB8879A@PH0PR08MB7020.namprd08.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2026-03-09 10:29:15 Re: [PATCH] Support automatic sequence replication
Previous Message Chao Li 2026-03-09 09:50:01 Re: DOC: fixes multiple errors in alter table doc