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.
24642 Commits
37 Branches
654 Tags
742 MiB
 
 
 
 
 
 
Tag: Branch: Tree: REL8_2_STABLE
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'REL8_2_STABLE'
${ noResults }
postgres/contrib/pgbench
History
Magnus Hagander 1f2378b1ea
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 pgbench: More fix with handling default scaling factor in the default 19 years ago
README.pgbench_jis pgbench: More fix with handling default scaling factor in the default 19 years ago
pgbench.c Fix possible core dump from pgbench -d option. Julius Stroffek 18 years ago

README.pgbench_jis
Escape 

pgbench README		2006/10/21 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<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BPostgreSQL<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$N%Y%s%A%^!<%/%F%9%H$r9T$J$&%W%m%0%i%`$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$*$/$3$H$,$G$-$^$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$r;H$C$FFH<+$N%H%i%s%6%/%7%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%s$rDj5A$9$k>l9g$O!$<+J,$G%G!<%?%Y!<%9$N=i4|2=$r$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
		-f <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$G;XDj$7$?%U%!%$%k$+$i%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;2>H$9$k$K$O<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B scale <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$H$$$&JQ?tL>$r;HMQ$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

-D varname=value

		<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BJQ?t$rDj5A$7$^$9!%Dj5A$7$?JQ?t$O<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$G;XDj$7$?%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$+$i;2>H$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%*%W%7%g%s$G$OJQ?tL>$HCM$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%$%3!<%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$G6h@Z$C$F;XDj$7$^$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%*%W%7%g%s$OJ#?t;XDj$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!$%G%U%)%k%H$N;vA0%/%j!<%s%"%C<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=hM}$K2C$(!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Baccounts<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>(BVACUUM ANALYZE<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

		-v -n <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$NN>J}$r>JN,$7$?>l9g$N%G%U%)%k%H;vA0%/%j!<%s%"%C<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=hM}$O!$0J2<$N=hM}$r9T$$$^$9!%<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$+$i$NA49T:o=|<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
		- branches, tellers, 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>(BVACUUM

		<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-f<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$r;H$C$FFH<+<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$N%H%i%s%6%/%7%g%s$rDj5A$9$k>l9g$O!$<+J,$G%G!<%?%Y!<%9$N=i4|2=$r$7$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$/I,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!%%F!<%V%k$H%$%s%G%C%/%9$N%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%$%:$O%G!<%?%Y!<%9%5%$%:$O35$M$=$l$>$l!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B130MB<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>(B1.3GB<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>(B13GB<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$[$I$K$J$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$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$?$H$($P!$%9%1!<%j%s%0%U%!%/%?!<$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

\set name operand1 [ operator operand2 ]
	<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BHo1i;;?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B operand1 <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 operand2 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$r1i;;;R<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B operator <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K$h$C$F1i;;$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$?7k2L$rJQ?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B name <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K@_Dj$7$^$9!%8=>u$G$O@0?t$N;MB'1i;;$N$_$KBP<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>$B1~$7$F$$$^$9!%$J$*!$1i;;;R$H<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B 2 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$DL\$NHo1i;;?t$r>JN,$9$k$HC1=c<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 1 <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$DL\$NHo1i;;?t$rJQ?t$K@_Dj$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$K1i;;$N7k2L$r@_Dj$9$k$K$O!$<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B\set <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%a%?%3%^%s%I$r;HMQ$7$F0J<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>$B2<$N$h$&$K5-=R$7$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

	\set ntellers 10 * :tp

	<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 ntellers <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K%9%1!<%j%s%0%U%!%/%?!<<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%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$G;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$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>$BG\$7$?7k2L$r@_Dj$7$^$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!%<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$O<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$*$h$S%a%?%3%^%s%I$+$i;2>H$G$-$^$9!%$=$l$K$O0J2<$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$h$&$KJQ?tL>$NA0$K%3%m%s$rIU$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>$BJQ?t$rDj5A$9$k$K$O%a%?%3%^%s%I0J30$K<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%*%W%7%g%s$r;HMQ$9$k$3$H$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$^$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%*%W%7%g%s$GDj5A$7$?JQ?t$bJQ?tL>$NA0$K%3%m%s$rIU$1$F;2>H$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!%<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>$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

\set nbranches :scale
\set ntellers 10 * :scale
\set naccounts 100000 * :scale
\setrandom aid 1 :naccounts
\setrandom bid 1 :nbranches
\setrandom tid 1 :ntellers
\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, current_timestamp)
END

<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 branches <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%F!<%V%k$N%?%W%k?t$+$i<+F0E*$K@_Dj$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$?$$>l9g!$0J2<$N$h$&$K<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%s$H%7%'%k$N%3%^%s%ICV49$J$I$rAH$_9g<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$;$^$9!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

pgbench -s $(psql -At -c "SELECT count(*) FROM branches") -f tpc_b.sql

<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$J$*!$<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$?>l9g!$%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%"$O<+F0E*$K9T$o$l$^$;$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"#: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

2006/10/21
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B99$K%G%U%)%k%H$N%9%1!<%j%s%0%U%!%/%?$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bbranches<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$+$i<h$C$F$3$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$$%P%0$r=$@5!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2006/09/13
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$BJQ?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Btps<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$OJ6$i$o$7$$$N$G<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bscale<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$KJQ99!%%G%U%)%k%H%7%J%j%*$N;~$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%G%U%)%k%H$N%9%1!<%j%s%0%U%!%/%?$r<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(Bbranches<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$+$i<h$C$F$3$J$$%P%0$r=$@5!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B

2006/07/26
	* <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B:4F#$5$s$N%Q%C%A$rE,MQ!%0J2<$N5!G=DI2C!%<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(BPostgreSQL 8.2<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B$K<h$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>$B9~$^$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>$BJQ?t<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B tps
	    -s <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%*%W%7%g%s$G;XDj$7$?%9%1!<%j%s%0%U%!%/%?!<$r%U%!%$%kFb$GJQ?t$H$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$F;2>H$9$k5!G=<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%*%W%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%3%^%s%I$N%*%W%7%g%s$H$7$FDj5A$7$?JQ?t$r%U%!%$%kFb$+$i;2>H$9$k5!G=<span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>(B
	\set <span class="escaped-code-point" data-escaped="[U+001B]"><span class="char"></span></span>$B%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%U%!%$%kFb$G;MB'1i;;$r9T$$!"$=$N7k2L$rJQ?t$KBeF~$9$k5!G=<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