open-dsi
/
postgres
mirror of https://github.com/postgres/postgres
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22323 Commits
37 Branches
654 Tags
742 MiB
 
 
 
 
 
 
Tag: Branch: Tree: REL8_1_STABLE
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'REL8_1_STABLE'
${ noResults }
postgres/contrib/pgbench
History
Magnus Hagander 3fb50a7288
Convert cvsignore to gitignore, and add .gitignore for build targets. 		15 years ago
..
.gitignore Convert cvsignore to gitignore, and add .gitignore for build targets. 15 years ago
Makefile PGXS should be set with := not =, as specified in the documentation, 20 years ago
README.pgbench Allow multiple -f options. 20 years ago
README.pgbench_jis Oops. Partially saved file was committed. 20 years ago
pgbench.c Back port patch. 19 years ago

README.pgbench_jis
Escape 

pgbench README		2005/09/29 Tatsuo Ishii

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bpgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$O!)<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O%Y%s%A%^!<%/%F%9%H$r9T$J$&%W%m%0%i%`$G$9!%:#$N$H$3$m<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 
PostgreSQL <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B@lMQ$G$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B select/update/insert <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r4^$`%H%i%s%6%/%7%g%s$r<B9T$7!$A4BN$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B<B9T;~4V$H<B:]$K40N;$7$?%H%i%s%6%/%7%g%s$N?t$+$i<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BIC4V$K<B9T$G$-$?%H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%i%s%6%/%7%g%s?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B (tps) <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$rI=<($7$^$9!%=hM}$NBP>]$H$J$k%F!<%V%k$O%G%U%)<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%k%H$G$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 10<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BK|%?%W%k$N%G!<%?$r4^$_$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B<B:]$NI=<($O0J2<$N$h$&$J46$8$G$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

number of clients: 4
number of transactions per client: 100
number of processed transactions: 400/400
tps = 19.875015(including connections establishing)
tps = 20.098827(excluding connections establishing)

pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B JDBCBench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$$$&!$$b$H$b$H$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B MySQL <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BMQ$K=q$+$l$?<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B JDBC <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BMQ$N%Y<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%s%A%^!<%/%W%m%0%i%`$r;29M$K:n@.$5$l$^$7$?!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bpgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$NFCD'<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

o C <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B8@8l$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B libpq <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$@$1$G=q$+$l$F$$$k$N$G0\?"@-$,9b$/!$4JC1$K%$%s%9%H!<<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%k$G$-$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

o pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B libpq <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$NHsF14|=hM}5!G=$r;H$C$F%^%k%A%f!<%64D6-$r%7%_%e%l!<<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%H$7$^$9!%MF0W$KF1;~@\B34D6-$r%F%9%H$G$-$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bpgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N%$%s%9%H!<%k<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

PostgreSQL<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r%3%s%Q%$%k!$%$%s%9%H!<%k$7$?8e<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

$ make
$ make install

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bpgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N;H$$J}<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

$ pgbench [<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%G!<%?%Y!<%9L><span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B]

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$G$9!%%G!<%?%Y!<%9L>$r>JN,$9$k$H!$%f!<%6L>$HF1$8%G!<%?%Y!<%9$r;XDj$7$?<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$b$N$H$_$J$7$^$9!%%G!<%?%Y!<%9$O8e=R$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B -i <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$r;H$C$F$"$i$+$8$a<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B=i4|2=$7$F$*$/I,MW$,$"$j$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K$O$$$m$$$m$J%*%W%7%g%s$,$"$j$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-h <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%[%9%HL><span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B	PostgreSQL<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N%G!<%?%Y!<%9%G!<%b%s<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B postmaster <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$NF0<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$$$F$$$k%[%9%HL>$r;XDj$7$^$9!%>JN,$9$k$H<+%[%9%H$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B Unix domain
		socket <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$G@\B3$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-p <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%]!<%HHV9f<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B	postmaster <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N;HMQ$9$k%]!<%HHV9f$r;XDj$7$^$9!%>JN,$9$k$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 5432
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$,;XDj$5$l$?$b$N$H$_$J$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-c <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%/%i%$%"%s%H?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BF1;~<B9T%/%i%$%"%s%H?t$r;XDj$7$^$9!%>JN,;~$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
			1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$J$j$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bpgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$OF1;~<B9T%/%i%$%"%s%HKh$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
			<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%U%!%$%k%G%#%9%/%j%W%?$r;HMQ$9$k$N$G!$;HMQ2DG=<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
			<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%U%!%$%k%G%#%9%/%j%W%??t$r1[$($k%/%i%$%"%s%H?t$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
			<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B;XDj$G$-$^$;$s!%;HMQ2DG=%U%!%$%k%G%#%9%/%j%W%??t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
			<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B limit <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$d<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B ulimit <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%3%^%s%I$GCN$k$3$H$,$G$-$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-t <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%H%i%s%6%/%7%g%s?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B3F%/%i%$%"%s%H$,<B9T$9$k%H%i%s%6%/%7%g%s?t$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
			<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B;XDj$7$^$9!%>JN,;~$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 10 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$J$j$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-s <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%9%1!<%j%s%0%U%!%/%?!<<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

		-i <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$H0l=o$K;HMQ$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%9%1!<%j%s%0%U%!%/%?!<$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B1<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B0J>e$N@0?t!%%9%1!<%j%s%0%U%!<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%/%?!<$rJQ$($k$3$H$K$h$j!$%F%9%H$NBP>]$H$J$k%F!<%V%k$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BBg$-$5$,<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 10<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BK|<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B x [<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%9%1!<%j%s%0%U%!%/%?!<<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B]<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K$J$j$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%G%U%)%k%H$N%9%1!<%j%s%0%U%!%/%?!<$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$G$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-U login	DB<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%f!<%6$N%m%0%$%sL>$r;XDj$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-P password	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%Q%9%o!<%I$r;XDj$7$^$9!%$J$*!$$3$N%*%W%7%g%s$r;H$&$H!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%Q%9%o!<%I$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bps<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%3%^%s%I$G8+$i$l$k$J$I!$%;%-%e%j%F%#%[!<<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%k$K$J$k2DG=@-$,$"$k$N$G!$%F%9%HMQ$K$N$_$*;H$$2<$5$$!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-n		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$N%*%W%7%g%s$r;XDj$9$k$H!$%Y%s%A%^!<%/3+;OA0$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B vacuum <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		history <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N%/%j%"$r9T$J$$$^$;$s!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-v		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$N%*%W%7%g%s$r;XDj$9$k$H!$%Y%s%A%^!<%/3+;OA0$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B vacuum <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		history <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N%/%j%"$r9T$J$$$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B-v <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B -n <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r>JN,$9$k$H!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B:G>.8B$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B vacuum <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$J$I$r9T$$$^$9!%$9$J$o$A!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bhistory <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N:o=|!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B history, branches, history <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B vacuum <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r9T$$$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$l$O!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bvacuum <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N;~4V$r:G>.8B$K$7$J$,$i!$%Q%U%)!<%^%s%9$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B1F6A$9$k%4%_A]=|$r8z2LE*$K9T$$$^$9!%DL>o$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B -v <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B -n <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B>JN,$9$k$3$H$r$*$9$9$a$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-S		TPC-B<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N%H%i%s%6%/%7%g%s$G$O$J$/!$8!:w$N$_$N%H%i%s%6%/%7%g%s$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B<B9T$7$^$9!%8!:w%9%T!<%I$rB,Dj$7$?$$$H$-$K;H$$$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-N
		"branches"<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B"tellers"<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%F!<%V%k$N99?7$r9T$$$^$;$s!%$3$l<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K$h$C$F<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B"branches"<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B"tellers"<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$X$NBgNL$N99?7$N6%9g$N$J<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$$>uBV$G$NB,Dj$r9T$$$^$9!%$7$?$,$C$F<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BTPC-B<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N%9%Z%C%/$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$OE,9g$7$J$/$J$j$^$9$,!$$h$j8=<BE*$JIi2Y$r%F%9%H$9$k$3<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$,$G$-$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-f filename	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%H%i%s%6%/%7%g%s$NFbMF$,5-=R$5$l$?%U%!%$%kL>$r;XDj$7$^<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$9!%$3$N%*%W%7%g%s$r;XDj$9$k$H!$%U%!%$%k$K5-=R$5$l$?Fb<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BMF$N%H%i%s%6%/%7%g%s$r<B9T$7$^$9!%$J$*!$%Y%s%A%^!<%/$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BBP>]$H$J$k%G!<%?%Y!<%9$O$"$i$+$8$a=i4|2=$7$F$*$/I,MW$,<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$"$j$^$9!%F~NO%U%)!<%^%C%H$K$D$$$F$O8e=R$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-C		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$N%*%W%7%g%s$r;XDj$9$k$H!$:G=i$K3NN)$7$?%3%M%/%7%g%s<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r;H$$2s$9$N$G$O$J$/!$3F%H%i%s%6%/%7%g%s$4$H$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BDB<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$X$N@\<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BB3$r9T$$$^$9!%%3%M%/%7%g%s$N%*!<%P!<$X%C%I$rB,Dj$9$k$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$KM-8z$G$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-l		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B8D!9$N%H%i%s%6%/%7%g%s$N<B9T;~4V$r5-O?$7$^$9!%5-O?@h$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%+%l%s%H%G%#%l%/%H%j0J2<$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bpgbench_log.xxx<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$$$&%U%!%$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%k$G$9!%%U%!%$%k$N%U%)!<%^%C%H$O!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		
			<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%/%i%$%"%s%H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BID	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%H%i%s%6%/%7%g%sHV9f<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B  <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B;~4V<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$J$C$F$$$^$9!%;~4V$O%^%$%/%mICC10L$G$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-d		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%G%P%C%0%*%W%7%g%s!%MM!9$J>pJs$,I=<($5$l$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#%G!<%?%Y!<%9$N=i4|2=<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$G%Y%s%A%^!<%/%F%9%H$r<B;\$9$k$?$a$K$O!$$"$i$+$8$a%G!<%?%Y!<%9<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r=i4|2=$7!$%F%9%H%G!<%?$r:n$kI,MW$,$"$j$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

$ pgbench -i [<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%G!<%?%Y!<%9L><span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B]

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$l$K$h$j0J2<$N%F!<%V%k$,:n$i$l$^$9<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B(<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%9%1!<%j%s%0%U%!%/%?!<<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B == 1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N>l9g<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B)<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B!vCm0U!v<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BF1$8L>A0$N%F!<%V%k$,$"$k$H:o=|$5$l$F$7$^$&$N$G$4Cm0U2<$5$$!*!*<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%F!<%V%kL><span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%?%W%k?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
-------------------------
branches	1
tellers		10
accounts	100000
history		0

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%9%1!<%j%s%0%U%!%/%?!<$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 10,100,1000 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$J$I$KJQ99$9$k$H!$>e5-%?%W%k?t$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$=$l$K1~$8$F<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B10<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BG\!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B100<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BG\!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B1000<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BG\$K$J$j$^$9!%$?$H$($P!$%9%1!<%j%s%0%U%!<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%/%?!<$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 10 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$9$k$H!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%F!<%V%kL><span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%?%W%k?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
-------------------------
branches	10
tellers		100
accounts	1000000
history		0

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K$J$j$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#!V%H%i%s%6%/%7%g%s!W$NDj5A<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$G$O!$0J2<$N%7!<%1%s%9$rA4It40N;$7$F<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B1<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%H%i%s%6%/%7%g%s$H?t$($F<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$$$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

(1) begin;

(2) update accounts set abalance = abalance + :delta where aid = :aid;
    <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$3$G!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B:delta<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B1<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$+$i<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B1000<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$^$G$NCM$r<h$kMp?t!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B:aid <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 1<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$+$i<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B100000<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$^$G<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
    <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$NCM$r<h$kMp?t$G$9!%0J2<!$Mp?t$NCM$O$=$l$>$l$3$N%H%i%s%6%/%7%g%s$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
    <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BCf$G$OF1$8CM$r;H$$$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

(3) select abalance from accounts where aid = :aid;
    <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$3$G$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B1<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B7o$@$18!:w$5$l$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

(4) update tellers set tbalance = tbalance + :delta where tid = :tid;
    <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$3$G<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B :tid <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 1<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$+$i<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B10<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N4V$NCM$r$H$kMp?t$G$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

(5) update branches set bbalance = bbalance + :delta where bid = :bid;
    <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$3$G<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B :bid <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$+$i<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B[<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%9%1%j%s%0%U%!%/%?!<<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B]<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N4V$NCM$r<h$kMp?t$G$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

(6) insert into history(tid,bid,aid,delta) values(:tid,:bid,:aid,:delta);

(7) end;

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#F~NO%U%!%$%k$N%U%)!<%^%C%H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-f <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$r;XDj$7$F%H%i%s%6%/%7%g%s$K4^$^$l$k<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B SQL <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%3%^%s%I$NFbMF$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B5-=R$7$?%U%!%$%k$rFI$_9~$`$3$H$,$G$-$^$9!%F~NO%U%!%$%k$K$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B9T$K$D$-<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 
1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$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<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%a%s%H$r0UL#$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-f <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$OJ#?t;XDj$G$-$^$9!%$3$N>l9g$O3F%H%i%s%6%/%7%g%s$K$O%i%s<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%@%`$KA*$P$l$?%U%!%$%k$K5-=R$5$l$?<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BSQL<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$,<B9T$5$l$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%3%^%s%I$K$O!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BSQL <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%3%^%s%I$K2C$(!$%P%C%/%9%i%C%7%e$G;O$^$k%a%?%3%^%s%I<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r5-=R$G$-$^$9!%%a%?%3%^%s%I$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B<+?H$K$h$C$F<B9T$5$l$^$9!%%a%?<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%3%^%s%I$N7A<0$O%P%C%/%9%i%C%7%e!$$=$ND>8e$K%3%^%s%I$NF0;l!$$=$N<!$K0z<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B?t$,B3$-$^$9!%F0;l%3%^%s%I$H0z?t!$$^$?$=$l$>$l$N0z?t$O6uGrJ8;z$K$h$C$F<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B6h@Z$i$l$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B8=:_$N$H$3$m!$0J2<$N%a%?%3%^%s%I$,Dj5A$5$l$F$$$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

\setrandom name min max
	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B:G>.CM<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B min <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H:GBgCM<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B max <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N4V$NCM$r<h$kMp?t$r!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bname <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BJQ?t$K@_Dj<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BJQ?t$KMp?t$r@_Dj$9$k$K$O!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B\setrandom <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%a%?%3%^%s%I$r;HMQ$7$F0J2<$N$h$&<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K5-=R$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

\setrandom aid 1 100000

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$l$O!$JQ?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B aid <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$+$i<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 100000 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N4V$NMp?t$r@_Dj$7$^$9!%$^$?!$JQ?t$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BCM$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B SQL <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%3%^%s%I$KKd$a9~$`$K$O!$0J2<$N$h$&$K$=$NL>A0$NA0$K%3%m%s$rIU<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$1$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

SELECT abalance FROM accounts WHERE aid = :aid

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BNc$($P!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BTCP-B <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$KN`;w$7$?%Y%s%A%^!<%/$r7WB,$9$k$K$O!$0J2<$N$h$&$K%H%i%s<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%6%/%7%g%s$NFbMF$r%U%!%$%k$K5-=R$7!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B-f <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$K$h$C$F$=$N%U%!%$%k<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r;XDj$7$F<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r<B9T$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

\setrandom aid 1 100000
\setrandom bid 1 1
\setrandom tid 1 10
\setrandom delta 1 10000
BEGIN
UPDATE accounts SET abalance = abalance + :delta WHERE aid = :aid
SELECT abalance FROM accounts WHERE aid = :aid
UPDATE tellers SET tbalance = tbalance + :delta WHERE tid = :tid
UPDATE branches SET bbalance = bbalance + :delta WHERE bid = :bid
INSERT INTO history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, 'now')
END

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#:n<T$H%i%$%;%s%9>r7o<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

pgbench <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O@P0f<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BC#IW$K$h$C$F=q$+$l$^$7$?!%%i%$%;%s%9>r7o$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B pgbench.c <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BKAF,$K=q$$$F$"$j$^$9!%$3$N>r7o$r<i$k8B$jL5=~$GMxMQ$7!$$^$?<+M3$K:FG[IU<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$G$-$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B"#2~DjMzNr<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2005/09/29
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B:4F#$5$s$N%Q%C%A$rE,MQ!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B-f <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$NDI2C!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

[<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$N4V$$$m$$$mJQ99$,$"$C$?$h$&$@$,<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BREADME<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O%a%$%s%F%J%s%9$5$l$F$$$J$$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B]

2003/11/26
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BC+ED$5$s$N%Q%C%A$rE,MQ!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bpgbench -i<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N:]$K!$8e$+$i<g%-!<$r:n@.<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	  <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$9$k$h$&$K$7$?!%$3$l$K$h$C$F=i4|2=$N<B9T;~4V$,BgI}$KC;=L$G$-<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	  <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$k<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B(<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O$:<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B)<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2003/06/10
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%a%b%j$,=i4|2=$5$l$F$$$J$$%P%0$r=$@5<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B4D6-JQ?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BPGHOST, PGPORT, PGUSER<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$rG'<1$9$k$h$&$K$7$?!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2002/07/20
	* Nei Conway<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$5$s$N%Q%C%A$rE,MQ!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	* -l <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$NDI2C!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2002/02/24
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$3$3$+$i$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B7.3<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BMQ$NJQ99$G$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	* CHECKPOINT<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$NH/9T$r$d$a$^$7$?!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	* -N <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$rDI2C$7$^$7$?!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2001/10/24
	* PostgreSQL 7.2<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$G!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B"time"<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$,M=Ls8l$K$J$C$?$N$G!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B"mtime"<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$KJQ99<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$7$?!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2001/09/09
	* PostgreSQL 7.2<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BMQ$K!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B-U, -P, -C <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$rDI2C$7$^$7$?!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2000/1/15 pgbench-1.2 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B PostgreSQL <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B contribute <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$5$l$^$7$?!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	* -v <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%sDI2C<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

1999/09/29 pgbench-1.1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%j%j!<%9<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BC+ED$5$s$K$h$k<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bcygwin<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BBP1~%Q%C%A<h$j9~$_<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%P%C%/%(%s%I%/%i%C%7%e;~$NBP1~<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	* -S <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%sDI2C<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

1999/09/04 pgbench-1.0 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%j%j!<%9<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B