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

Hi, everybody 

I took measurements of the performance of the modes at home and received 
data corresponding to the data of the patch author. All measurements were 
performed in the single transaction mode S (default mode). I took five 
measurements each and got the average. I took measurements at the WSL.

------------------------------------------------ 
[ Client / Text mode ] 
pgbench -i -Idtg -s1000 
average table creation: 144.188 s 
[ Client / Binary mode ] 
pgbench -i -Idtc -s1000 
average table creation: 105.914 s 

[ Server / generate_series ] 
pgbench -i -IdtG -s1000 
average table creation: 265.912 s 
[ Server / Unnest ] 
pgbench -i -IdtU -s1000 
average table creation: 279.508 s 
------------------------------------------------ 

I also took measurements on a simple Linux machine available to me. 

------------------------------------------------ 
[ Client / Text mode ] 
pgbench -i -Idtg -s1000 
average table creation: 130.524 s 
[ Client / Binary mode ] 
pgbench -i -Idtc -s1000 
average table creation: 105.29 s 
------------------------------------------------ 

In my measurements, binary mode turned out to be about 25% more productive. 
Unnest mode is slightly slower than generate_series. Although WSL is not 
the best environment for testing, it was the closest option at hand. 
Measurements on a separate Linux machine confirmed the results. The overall 
performance changes correspond to the author's measurements. 

Best regards, 
Egor