Re: pgbench - extend initialization phase control

Fabien COELHO <coelho@cri.ensmp.fr>

From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Ibrar Ahmed <ibrar.ahmad@gmail.com>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2019-06-11T04:43:13Z
Lists: pgsql-hackers
Hello Ibrar,

> Does both client/server side data generation in a single command make 
> sense?

I think yes, especially with the other patch which adds timing measures to 
the initialization phases. It really depends what you want to test.

With client-side generation you test the libpq COPY interface and network 
protocol for bulk loading.

With server-side generation you are get the final result faster when 
network bandwidth is low, and somehow you are testing a different kind of 
small query which generates a lot of data.

-- 
Fabien.



Commits

  1. Add query cancellation capabilities in pgbench init phase

  2. Add "G" (server-side data generation) as an initialization step in pgbench.