From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
---|---|
To: | Hannu Krosing <hannuk(at)google(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Dimitri Fontaine <dim(at)tapoueh(dot)org> |
Subject: | Re: pgbench - adding pl/pgsql versions of tests |
Date: | 2023-01-10 13:43:58 |
Message-ID: | ce21ec88-761a-d4ff-749a-cf2c21ae85b@mines-paristech.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
> The attached patch adds pl/pgsql versions of "tpcb-like" and
> "simple-update" internal test scripts
Why not, it makes sense because it is relevant to some usage patterns.
Why not having the select version as a version as well?
If we are going to follow this road, we could also consider
"combined" queries with \; as well?
> $ pgbench -b list
> Available builtin scripts:
> tpcb-like: <builtin: TPC-B (sort of)>
> plpgsql-tpcb-like: <builtin: TPC-B (sort of) as a pl/pgsql function>
> simple-update: <builtin: simple update>
> plpgsql-simple-update: <builtin: simple update as a pl/pgsql function>
> select-only: <builtin: select only>
>
> which one can run using the -b / --builtin= option
ISTM that the -b had a fast selection so that only a prefix was enough to
select a script (-b se = -b select-only). Maybe such convenient shortcut
should be preserved, it seems that the long name will be needed for the pl
versions.
> And a flag --no-functions which lets you not to create the functions at init
Hmmm. Not so sure.
> there are also character flags to -I / --init ,
> -- Y to drop the functions and
> -- y to create the functions. Creating is default behaviour, but can
> be disabled fia long flag --no-functions )
Ok.
> I selected Yy as they were unused and can be thought of as "inverted
> lambda symbol" :)
:-)
> If there are no strong objections, I'll add it to the commitfest as well
Please do that.
--
Fabien Coelho.
From | Date | Subject | |
---|---|---|---|
Next Message | Matthias van de Meent | 2023-01-10 14:03:42 | Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE |
Previous Message | Robert Haas | 2023-01-10 13:12:38 | Re: split TOAST support out of postgres.h |