pgsql: pgbench: add \cset and \gset commands

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: pgbench: add \cset and \gset commands
Date: 2019-01-10 16:42:49
Message-ID: E1ghdPt-0001P1-8U@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

pgbench: add \cset and \gset commands

These commands allow assignment of values produced by queries to pgbench
variables, where they can be used by further commands. \gset terminates
a command sequence (just like a bare semicolon); \cset separates
multiple queries in a compound command, like an escaped semicolon (\;).
A prefix can be provided to the \-command and is prepended to the name
of each output column to produce the final variable name.

This feature allows pgbench scripts to react meaningfully to the actual
database contents, allowing more powerful benchmarks to be written.

Authors: Fabien Coelho, Álvaro Herrera
Reviewed-by: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
Reviewed-by: Stephen Frost <sfrost(at)snowman(dot)net>
Reviewed-by: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Reviewed-by: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Reviewed-by: Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com>
Discussion: https://postgr.es/m/alpine.DEB.2.20.1607091005330.3412@sto

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/6260cc550b0e60052168518a0338e440b67cf24e

Modified Files
--------------
doc/src/sgml/ref/pgbench.sgml | 85 +++++
src/bin/pgbench/pgbench.c | 545 ++++++++++++++++++++-------
src/bin/pgbench/t/001_pgbench_with_server.pl | 82 +++-
src/fe_utils/psqlscan.l | 24 +-
src/include/fe_utils/psqlscan.h | 2 +
src/include/fe_utils/psqlscan_int.h | 1 +
6 files changed, 602 insertions(+), 137 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2019-01-10 17:00:45 pgsql: Don't use address of array as boolean
Previous Message Michael Paquier 2019-01-10 05:11:33 pgsql: Update unaccent rules with release 34 of CLDR for Latin-ASCII.xm