Re: Use COPY for populating all pgbench tables

Gregory Smith <gregsmithpgsql@gmail.com>

From: Gregory Smith <gregsmithpgsql@gmail.com>
To: Gurjeet Singh <gurjeet@singh.im>
Cc: Tristan Partin <tristan@neon.tech>, pgsql-hackers@postgresql.org
Date: 2023-06-10T00:41:50Z
Lists: pgsql-hackers
On Fri, Jun 9, 2023 at 1:25 PM Gurjeet Singh <gurjeet@singh.im> wrote:

> >     $ pgbench -i -I dtGvp -s 500
>
> The steps are severely under-documented in pgbench --help output.
>

I agree it's not easy to find information.  I just went through double
checking I had the order recently enough to remember what I did.  The man
pages have this:

> Each step is invoked in the specified order. The default is dtgvp.

Which was what I wanted to read.  Meanwhile the --help output says:

>  -I, --init-steps=[dtgGvpf]+ (default "dtgvp")

%T$%%Which has the information without a lot of context for what it's used
for.  I'd welcome some text expansion that added a minimal but functional
improvement to that the existing help output; I don't have such text.

Commits

  1. pgbench: Use COPY for client-side data generation

  2. pgbench: Add TAP tests to check consistency of data generated

  3. pgbench: Move constant into format string