Skip to content

Commit f50ae06

Browse files
committed
Allow multiple -f options.
Make pgbench "script driven" to eliminate hard coded transaction scenario. (Tatsuo Ishii)
1 parent ffa156b commit f50ae06

File tree

3 files changed

+354
-472
lines changed

3 files changed

+354
-472
lines changed

contrib/pgbench/README.pgbench

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
pgbench README 2005/09/29 Tatsuo Ishii
1+
pgbench README 2005/10/04 Tatsuo Ishii
22

33
o What is pgbench?
44

@@ -166,6 +166,9 @@ o -f option
166166
command consists of multiple lines are not supported. Empty lines
167167
and lines begging with "--" will be ignored.
168168

169+
Multiple -f options are allowed. In this case each transaction is
170+
assigned randomly chosen script.
171+
169172
SQL commands can include "meta command" which begins with "\" (back
170173
slash). A meta command takes some arguments separted by white
171174
spaces. Currently following meta command is supported:

contrib/pgbench/README.pgbench_jis

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -180,10 +180,12 @@ pgbench $B$G$O!$0J2<$N%7!<%1%s%9$rA4It40N;$7$F(B1$B%H%i%s%6%/%7%g%s$H?t$($F(
180180

181181
$B"#F~NO%U%!%$%k$N%U%)!<%^%C%H(B
182182

183-
pgbench $B$G$O!$(B-f $B%*%W%7%g%s$r;XDj$7$F%H%i%s%6%/%7%g%s$K4^$^$l$k(B SQL $B%3(B
184-
$B%^%s%I$NFbMF$r5-=R$7$?%U%!%$%k$rFI$_9~$`$3$H$,$G$-$^$9!%F~NO%U%!%$%k$K(B
185-
$B$O(B 1 $B9T$K$D$-(B 1 $B$D$N%3%^%s%I$r5-=R$7$^$9!%6u9T$OL5;k$5$l!$Fs=E%O%$%U%s(B
186-
$B$G;O$^$k9T$O%3%a%s%H$r0UL#$7$^$9!%(B
183+
-f $B%*%W%7%g%s$r;XDj$7$F%H%i%s%6%/%7%g%s$K4^$^$l$k(B SQL $B%3%^%s%I$NFbMF$r(B
184+
$B5-=R$7$?%U%!%$%k$rFI$_9~$`$3$H$,$G$-$^$9!%F~NO%U%!%$%k$K$O(B 1 $B9T$K$D$-(B
185+
1 $B$D$N%3%^%s%I$r5-=R$7$^$9!%6u9T$OL5;k$5$l!$Fs=E%O%$%U%s$G;O$^$k9T$O%3(B
186+
$B%a%s%H$r0UL#$7$^$9!%(B
187+
188+
-f $B%*%W%7%g%s$OJ#?t;XDj$G$-$^$9!%$3$N>l9g$O(B
187189

188190
$B%3%^%s%I$K$O!$(BSQL $B%3%^%s%I$K2C$(!$%P%C%/%9%i%C%7%e$G;O$^$k%a%?%3%^%s%I(B
189191
$B$r5-=R$G$-$^$9!%%a%?%3%^%s%I$O(B pgbench $B<+?H$K$h$C$F<B9T$5$l$^$9!%%a%?(B

0 commit comments

Comments
 (0)