Hello,
We (Neon) have noticed that pgbench can be quite slow to populate data
in regard to higher latency connections. Higher scale factors exacerbate
this problem. Some employees work on a different continent than the
databases they might be benchmarking. By moving pgbench to use COPY for
populating all tables, we can reduce some of the time pgbench takes for
this particular step.
I wanted to come with benchmarks, but unfortunately I won't have them
until next month. I can follow-up in a future email.
--
Tristan Partin
Neon (https://neon.tech)