On Thu, Mar 12, 2026 at 11:28 PM Boris Mironov <[email protected]> wrote: > > Hi Egor, > > Thank you very much for your time reviewing this patch > and guiding through some of its inefficiencies.
I like the idea of improving the performance of the initial data load in pgbench. That's definitely useful. I ran some tests on my MacBook (server and pgbench on the same machine) using different data loading options. Here are the results: ------------------------------------------------ [ Client / Text mode ] pgbench -i -Idtg -s100 done in 13.38 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 13.38 s). pgbench -i -Idtg -s1000 done in 151.81 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 151.81 s). [ Client / Binary mode ] pgbench -i -Idtc -s100 done in 18.32 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 18.31 s). pgbench -i -Idtc -s1000 done in 204.48 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 204.47 s). [ Server / generate_series ] pgbench -i -IdtG -s100 done in 21.30 s (drop tables 0.00 s, create tables 0.00 s, server-side generate 21.30 s). pgbench -i -IdtG -s1000 done in 230.94 s (drop tables 0.00 s, create tables 0.01 s, server-side generate 230.93 s). [ Server / Unnest ] pgbench -i -IdtU -s100 done in 23.16 s (drop tables 0.00 s, create tables 0.00 s, server-side generate 23.16 s). pgbench -i -IdtU -s1000 done in 249.08 s (drop tables 0.00 s, create tables 0.01 s, server-side generate 249.07 s). ------------------------------------------------ In my tests, text mode was faster than binary mode. Also, on the server side, generate_series() was faster than unnest(). So I'm wondering if there are specific conditions where binary mode or unnest() performs better. If not, it may not be worth supporting these additional data loading options... Regards, -- Fujii Masao
