Re: extend pgbench expressions with functions

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: extend pgbench expressions with functions
Date: 2016-02-14 16:28:16
Message-ID: alpine.DEB.2.10.1602141720370.16754@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hello Michaël,

>> I'll be happy if you do the review of the resulting split.
> OK, I am fine with this scenario as well. I have luckily done nothing yet.

Here is a 3 part v29:

a) add support for integer functions in pgbench, including turning
operators as functions, as well as some minimal infrastructure for
additional types (this allows to minimize the diffs with the next
patch which adds double).

b) add support for doubles, including setting double variables.
Note that variable are not explicitely typed. Add some
double-related functions, most interesting of them for pgbench
are the randoms.

c) remove \setrandom support (as thanks to part b \set x random(...) does
the same). Prints an error pointing to the replacement if \setrandom is
used in a pgbench script.


Attachment Content-Type Size
pgbench-funcs-29-a.patch text/x-diff 23.3 KB
pgbench-funcs-29-b.patch text/x-diff 25.5 KB
pgbench-funcs-29-c.patch text/x-diff 8.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-02-14 16:46:47 Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time
Previous Message Tom Lane 2016-02-14 16:11:58 Re: Removing Functionally Dependent GROUP BY Columns