| From: | lakshmi <lakshmigcdac(at)gmail(dot)com> |
|---|---|
| To: | Mircea Cadariu <cadariu(dot)mircea(at)gmail(dot)com> |
| Cc: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "tomas(at)vondra(dot)me" <tomas(at)vondra(dot)me>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
| Subject: | Re: parallel data loading for pgbench -i |
| Date: | 2026-05-09 08:02:44 |
| Message-ID: | CAEvyyTgbQWO9aFtAB+T6O_wHpuwnGGbOUp7qzM8Gjt+mBwAXCw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, May 8, 2026 at 11:41 PM Mircea Cadariu <cadariu(dot)mircea(at)gmail(dot)com>
wrote:
> Hi Lakshmi and Hayato,
>
>
> Thanks a lot for your feedback.
>
> Attached for your consideration is v4, in which I address your remarks.
>
Hi Mircea, Hayato,
I tested the v4 patch on 19devel with a few different thread/partition
combinations.
The updated API looks much better now. I verified that:
- parallel loading works correctly with -j
- uneven partition distribution (for example 5 partitions with 2
threads) also works fine
- serial mode with -j 1 works again as expected
The workers appear to run concurrently, and VACUUM time remains relatively
small in my tests.
Overall, the new approach looks much cleaner and more flexible compared to
the earlier versions.
Thanks again for the update.
Best regards,
Lakshmi
| From | Date | Subject | |
|---|---|---|---|
| Previous Message | Henson Choi | 2026-05-09 07:43:18 | Re: Row pattern recognition |