Horton

Re: 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: Fujii Masao <masao.fujii@gmail.com>
Cc: btendouan <btendouan@oss.nttdata.com>, "ibrar.ahmad@gmail.com:" <pgsql-hackers@lists.postgresql.org>
Date: 2019-10-24T15:06:16Z
Lists: pgsql-hackers 
Hello,

>> Yep. Or anything else, including without (), to allow checking the
>> performance impact or non impact of transactions on the initialization
>> phase.
>
> Is there actually such performance impact? AFAIR most time-consuming part in
> initialization phase is the generation of pgbench_accounts data.

Maybe. If you cannot check, you can only guess. Probably it should be 
small, but the current version does not allow to check whether it is so.

-- 
Fabien.

Commits

  1. Add query cancellation capabilities in pgbench init phase

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