pgsql: Improve scripting language in pgbench

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve scripting language in pgbench
Date: 2018-01-09 15:02:51
Message-ID: E1eYvQR-0002LN-R9@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-committers pgsql-hackers

Improve scripting language in pgbench

Added:
- variable now might contain integer, double, boolean and null values
- functions ln, exp
- logical AND/OR/NOT
- bitwise AND/OR/NOT/XOR
- bit right/left shift
- comparison operators
- IS [NOT] (NULL|TRUE|FALSE)
- conditional choice (in form of when/case/then)

New operations and functions allow to implement more complicated test scenario.

Author: Fabien Coelho with minor editorization by me
Reviewed-By: Pavel Stehule, Jeevan Ladhe, me
Discussion: https://www.postgresql.org/message-id/flat/alpine(dot)DEB(dot)2(dot)10(dot)1604030742390(dot)31618(at)sto

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/ref/pgbench.sgml | 223 +++++++++++-
src/bin/pgbench/exprparse.y | 195 ++++++++++-
src/bin/pgbench/exprscan.l | 55 ++-
src/bin/pgbench/pgbench.c | 484 +++++++++++++++++++++++----
src/bin/pgbench/pgbench.h | 24 +-
src/bin/pgbench/t/001_pgbench_with_server.pl | 171 ++++++++--
6 files changed, 1026 insertions(+), 126 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2018-01-09 15:23:03 pgsql: Don't allow VACUUM VERBOSE ANALYZE VERBOSE.
Previous Message Robert Haas 2018-01-09 14:46:18 pgsql: Fix comment.

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2018-01-09 15:05:52 Re: [HACKERS] pgbench more operators & functions
Previous Message Masahiko Sawada 2018-01-09 14:49:35 Re: [HACKERS] Transactions involving multiple postgres foreign servers