Horton

pgbench - extend initialization phase control

Fabien COELHO <coelho@cri.ensmp.fr>

View thread View on postgr.es
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2019-04-06T16:31:11Z
Lists: pgsql-hackers

Attachments

Hello devs,

the attached patch adds some more control on the initialization phase.
In particular, ( and ) allow to begin/commit explicitely, and G generates 
the data server-side instead of client side, which might be a good idea 
depending on the available bandwidth.

Together with the previously submitted patch about getting stats on the 
initialization phase, the idea is to possibly improve this phase, or use 
it as a benchmark tool in itself.

-- 
Fabien.

Commits

  1. Add query cancellation capabilities in pgbench init phase

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