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
-
Add query cancellation capabilities in pgbench init phase
- 1d468b9ad81b 13.0 landed
-
Add "G" (server-side data generation) as an initialization step in pgbench.
- a386942bd29b 13.0 landed