pgbench: add --partitions and --partition-method options

Enterprise / PostgreSQL - Amit Kapila [postgresql.org] - 3 October 2019 02:57 EDT

These new options allow users to partition the pgbench_accounts table by specifying the number of partitions and partitioning method. The values allowed for partitioning method are range and hash.

This feature allows users to measure the overhead of partitioning if any.

Author: Fabien COELHO

b1c1aa5318 pgbench: add --partitions and --partition-method options.
doc/src/sgml/ref/pgbench.sgml | 25 +++
src/bin/pgbench/pgbench.c | 306 +++++++++++++++++++++++----
src/bin/pgbench/t/001_pgbench_with_server.pl | 20 +-
src/bin/pgbench/t/002_pgbench_no_server.pl | 7 +
4 files changed, 320 insertions(+), 38 deletions(-)

Upstream: git.postgresql.org


  • Share