Re: parallel data loading for pgbench -i - Mailing list pgsql-hackers

From Mircea Cadariu
Subject Re: parallel data loading for pgbench -i
Date
Msg-id ddca6fbd-1e99-4756-8b02-38f7962d464d@gmail.com
Whole thread Raw
In response to Re: parallel data loading for pgbench -i  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
Hi,

On 07/04/2026 10:00, Heikki Linnakangas wrote:
>
> This all makes more sense in the partitioned case. Perhaps we should 
> parallelize only when partitioned are used, and use only one thread 
> per partition.
>
Thanks for having a look. I attached v3 that parallelizes only the 
partitioned case, one thread per partition. Results:


patch:

pgbench -i -s 100 --partitions 10

done in 12.63 s (drop tables 0.05 s, create tables 0.01 s, client-side 
generate 5.98 s, vacuum 1.63 s, primary keys 4.96 s).


master:

pgbench -i -s 100 --partitions 10

done in 29.29 s (drop tables 0.00 s, create tables 0.02 s, client-side 
generate 16.31 s, vacuum 7.78 s, primary keys 5.18 s).

-- 
Thanks,
Mircea Cadariu

Attachment

pgsql-hackers by date:

Previous
From: Sandro Santilli
Date:
Subject: Re: Eliminating SPI / SQL from some RI triggers - take 3
Next
From: Antonin Houska
Date:
Subject: Re: Adding REPACK [concurrently]