Use COPY for populating all pgbench tables - Mailing list pgsql-hackers

From Tristan Partin
Subject Use COPY for populating all pgbench tables
Date
Msg-id CSTU5P82ONZ1.19XFUGHMXHBRY@c3po
Whole thread Raw
Responses Re: Use COPY for populating all pgbench tables
Re: Use COPY for populating all pgbench tables
Re: Use COPY for populating all pgbench tables
List pgsql-hackers
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)

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: memory leak in trigger handling (since PG12)
Next
From: Tom Lane
Date:
Subject: Re: Wrong command name in writeable-CTE related error messages