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

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: pgbench: add --partitions and --partition-method options.
Date: 2019-10-03 03:03:46
Message-ID: E1iFrP8-0008RK-Di@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

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
Reviewed-by: Amit Kapila, Amit Langote, Dilip Kumar, Asif Rehman, and
Alvaro Herrera
Discussion: https://postgr.es/m/alpine.DEB.2.21.1907230826190.7008@lancre

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b1c1aa53182372e907f3f7f090e7eb5f432a4c9a

Modified Files
--------------
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(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2019-10-03 09:38:17 Re: pgsql: pgbench: add --partitions and --partition-method options.
Previous Message Andres Freund 2019-10-02 17:07:40 Re: pgsql: Add hooks for session start and session end, take two