Annotation of pgsql/contrib/pgbench/README.pgbench_jis, revision 1.5
1.5 ! ishii 1: pgbench README 2002/02/24 Tatsuo Ishii ([email protected])
1.1 momjian 2:
3: $B"#(Bpgbench $B$H$O!)(B
4:
1.3 ishii 5: pgbench $B$O(B TPC-B$B$K;w$?%Y%s%A%^!<%/%F%9%H$r9T$J$&%W%m%0%i%`$G$9!%:#$N$H(B
6: $B$3$m(B PostgreSQL $B@lMQ$G$9!%(B
1.1 momjian 7:
1.3 ishii 8: pgbench $B$O(B select/update/insert $B$r4^$`%H%i%s%6%/%7%g%s$r<B9T$7!$A4BN$N(B
1.1 momjian 9: $B<B9T;~4V$H<B:]$K40N;$7$?%H%i%s%6%/%7%g%s$N?t$+$i(B 1 $BIC4V$K<B9T$G$-$?%H(B
1.3 ishii 10: $B%i%s%6%/%7%g%s?t(B (tps) $B$rI=<($7$^$9!%=hM}$NBP>]$H$J$k%F!<%V%k$O%G%U%)(B
11: $B%k%H$G$O(B 10$BK|%?%W%k$N%G!<%?$r4^$_$^$9!%(B
1.1 momjian 12:
1.3 ishii 13: $B<B:]$NI=<($O0J2<$N$h$&$J46$8$G$9!%(B
1.1 momjian 14:
15: number of clients: 4
16: number of transactions per client: 100
17: number of processed transactions: 400/400
18: tps = 19.875015(including connections establishing)
19: tps = 20.098827(excluding connections establishing)
20:
1.3 ishii 21: pgbench $B$O(B JDBCBench $B$H$$$&!$$b$H$b$H$O(B MySQL $BMQ$K=q$+$l$?(B JDBC $BMQ$N%Y(B
22: $B%s%A%^!<%/%W%m%0%i%`$r;29M$K:n@.$5$l$^$7$?!%(B
1.1 momjian 23:
24: $B"#(Bpgbench $B$NFCD'(B
25:
1.3 ishii 26: o C $B8@8l$H(B libpq $B$@$1$G=q$+$l$F$$$k$N$G0\?"@-$,9b$/!$4JC1$K%$%s%9%H!<(B
27: $B%k$G$-$^$9!%(B
1.1 momjian 28:
29: o pgbench $B$O(B libpq $B$NHsF14|=hM}5!G=$r;H$C$F%^%k%A%f!<%64D6-$r%7%_%e%l!<(B
1.3 ishii 30: $B%H$7$^$9!%MF0W$KF1;~@\B34D6-$r%F%9%H$G$-$^$9!%(B
1.1 momjian 31:
32: $B"#(Bpgbench $B$N%$%s%9%H!<%k(B
33:
1.2 ishii 34: (1) PostgreSQL$B$r(Bconfigure$B!$%3%s%Q%$%k$7$^$9!%(Bpgbench$B$N%$%s%9%H!<%k$@$1(B
35: $B$,L\E*$G$"$l$P!$(BPostgreSQL$B$N$9$Y$F$r%3%s%Q%$%k$9$kI,MW$O$"$j$^$;$s!%(B
36: PostgreSQL$B%=!<%9$N%H%C%W%G%#%l%/%H%j$G(Bconfigure$B$r$7$?8e!$(B
37: src/interface/libpq $B$G(B "make all" $B$r<B9T$9$l$P=`Hw40N;$G$9!%(B
1.1 momjian 38:
1.2 ishii 39: (2) $B$3$N%G%#%l%/%H%j$G(B make $B$r<B9T$7$^$9!%$=$&$9$k$H!$(B"pgbench" $B$H$$$&(B
40: $B<B9T%W%m%0%i%`$,$G$-$^$9!%$=$N$^$^<B9T$7$F$b9=$$$^$;$s$7!$(B"make
41: install" $B$r<B9T$7$F(B PostgreSQL $B$NI8=`<B9T%W%m%0%i%`%G%#%l%/%H%j(B
42: ($B%G%U%)%k%H$G$O(B /usr/local/pgsql/bin) $B$K%$%s%9%H!<%k$9$k$3$H$b$G$-(B
43: $B$^$9!%(B
1.1 momjian 44:
45: $B"#(Bpgbench $B$N;H$$J}(B
46:
47: $ pgbench [$B%G!<%?%Y!<%9L>(B]
48:
1.3 ishii 49: $B$G$9!%%G!<%?%Y!<%9L>$r>JN,$9$k$H!$%f!<%6L>$HF1$8%G!<%?%Y!<%9$r;XDj$7$?(B
50: $B$b$N$H$_$J$7$^$9!%%G!<%?%Y!<%9$O8e=R$N(B -i $B%*%W%7%g%s$r;H$C$F$"$i$+$8$a(B
51: $B=i4|2=$7$F$*$/I,MW$,$"$j$^$9!%(B
1.1 momjian 52:
1.3 ishii 53: pgbench $B$K$O$$$m$$$m$J%*%W%7%g%s$,$"$j$^$9!%(B
1.1 momjian 54:
55: -h $B%[%9%HL>(B PostgreSQL$B$N%G!<%?%Y!<%9%G!<%b%s(B postmaster $B$NF0(B
1.3 ishii 56: $B$$$F$$$k%[%9%HL>$r;XDj$7$^$9!%>JN,$9$k$H<+%[%9%H$K(B Unix domain
57: socket $B$G@\B3$7$^$9!%(B
1.1 momjian 58:
1.3 ishii 59: -p $B%]!<%HHV9f(B postmaster $B$N;HMQ$9$k%]!<%HHV9f$r;XDj$7$^$9!%>JN,$9$k$H(B 5432
60: $B$,;XDj$5$l$?$b$N$H$_$J$7$^$9!%(B
1.1 momjian 61:
1.3 ishii 62: -c $B%/%i%$%"%s%H?t(B $BF1;~<B9T%/%i%$%"%s%H?t$r;XDj$7$^$9!%>JN,;~$O(B
63: 1 $B$H$J$j$^$9!%(Bpgbench $B$OF1;~<B9T%/%i%$%"%s%HKh$K(B
64: $B%U%!%$%k%G%#%9%/%j%W%?$r;HMQ$9$k$N$G!$;HMQ2DG=(B
1.1 momjian 65: $B%U%!%$%k%G%#%9%/%j%W%??t$r1[$($k%/%i%$%"%s%H?t$O(B
1.3 ishii 66: $B;XDj$G$-$^$;$s!%;HMQ2DG=%U%!%$%k%G%#%9%/%j%W%??t(B
67: $B$O(B limit $B$d(B ulimit $B%3%^%s%I$GCN$k$3$H$,$G$-$^$9!%(B
1.1 momjian 68:
69: -t $B%H%i%s%6%/%7%g%s?t(B $B3F%/%i%$%"%s%H$,<B9T$9$k%H%i%s%6%/%7%g%s?t$r(B
1.3 ishii 70: $B;XDj$7$^$9!%>JN,;~$O(B 10 $B$H$J$j$^$9!%(B
1.1 momjian 71:
72: -s $B%9%1!<%j%s%0%U%!%/%?!<(B
73:
1.3 ishii 74: -i $B%*%W%7%g%s$H0l=o$K;HMQ$7$^$9!%(B
75: $B%9%1!<%j%s%0%U%!%/%?!<$O(B1$B0J>e$N@0?t!%%9%1!<%j%s%0%U%!(B
76: $B%/%?!<$rJQ$($k$3$H$K$h$j!$%F%9%H$NBP>]$H$J$k%F!<%V%k$N(B
77: $BBg$-$5$,(B 10$BK|(B x [$B%9%1!<%j%s%0%U%!%/%?!<(B]$B$K$J$j$^$9!%(B
78: $B%G%U%)%k%H$N%9%1!<%j%s%0%U%!%/%?!<$O(B 1 $B$G$9!%(B
79:
80: -U login DB$B%f!<%6$N%m%0%$%sL>$r;XDj$7$^$9!%(B
81:
82: -P password $B%Q%9%o!<%I$r;XDj$7$^$9!%$J$*!$$3$N%*%W%7%g%s$r;H$&$H!$(B
83: $B%Q%9%o!<%I$r(Bps$B%3%^%s%I$G8+$i$l$k$J$I!$%;%-%e%j%F%#%[!<(B
84: $B%k$K$J$k2DG=@-$,$"$k$N$G!$%F%9%HMQ$K$N$_$*;H$$2<$5$$!%(B
85:
86: -n $B$3$N%*%W%7%g%s$r;XDj$9$k$H!$%Y%s%A%^!<%/3+;OA0$K(B vacuum $B$H(B
87: history $B$N%/%j%"$r9T$J$$$^$;$s!%(B
88:
89: -v $B$3$N%*%W%7%g%s$r;XDj$9$k$H!$%Y%s%A%^!<%/3+;OA0$K(B vacuum $B$H(B
90: history $B$N%/%j%"$r9T$J$$$^$9!%(B-v $B$H(B -n $B$r>JN,$9$k$H!$(B
91: $B:G>.8B$N(B vacuum $B$J$I$r9T$$$^$9!%$9$J$o$A!$(Bhistory $B$N:o=|!$(B
92: $B$H(B history, branches, history $B$N(B vacuum $B$r9T$$$^$9!%(B
93: $B$3$l$O!$(Bvacuum $B$N;~4V$r:G>.8B$K$7$J$,$i!$%Q%U%)!<%^%s%9$K(B
94: $B1F6A$9$k%4%_A]=|$r8z2LE*$K9T$$$^$9!%DL>o$O(B -v $B$H(B -n $B$r(B
95: $B>JN,$9$k$3$H$r$*$9$9$a$7$^$9!%(B
96:
97: -S TPC-B$B$N%H%i%s%6%/%7%g%s$G$O$J$/!$8!:w$N$_$N%H%i%s%6%/%7%g%s$r(B
98: $B<B9T$7$^$9!%8!:w%9%T!<%I$rB,Dj$7$?$$$H$-$K;H$$$^$9!%(B
99:
1.5 ! ishii 100: -N
! 101: "branches"$B$H(B"tellers"$B%F!<%V%k$N99?7$r9T$$$^$;$s!%$3$l(B
! 102: $B$K$h$C$F(B"branches"$B$H(B"tellers"$B$X$NBgNL$N99?7$N6%9g$N$J(B
! 103: $B$$>uBV$G$NB,Dj$r9T$$$^$9!%$7$?$,$C$F(BTPC-B$B$N%9%Z%C%/$K(B
! 104: $B$OE,9g$7$J$/$J$j$^$9$,!$$h$j8=<BE*$JIi2Y$r%F%9%H$9$k$3(B
! 105: $B$H$,$G$-$^$9!%(B
! 106:
1.3 ishii 107: -C $B$3$N%*%W%7%g%s$r;XDj$9$k$H!$:G=i$K3NN)$7$?%3%M%/%7%g%s(B
108: $B$r;H$$2s$9$N$G$O$J$/!$3F%H%i%s%6%/%7%g%s$4$H$K(BDB$B$X$N@\(B
109: $BB3$r9T$$$^$9!%%3%M%/%7%g%s$N%*!<%P!<$X%C%I$rB,Dj$9$k$N(B
110: $B$KM-8z$G$9!%(B
1.1 momjian 111:
1.3 ishii 112: -d $B%G%P%C%0%*%W%7%g%s!%MM!9$J>pJs$,I=<($5$l$^$9!%(B
1.1 momjian 113:
114: $B"#%G!<%?%Y!<%9$N=i4|2=(B
115:
1.3 ishii 116: pgbench $B$G%Y%s%A%^!<%/%F%9%H$r<B;\$9$k$?$a$K$O!$$"$i$+$8$a%G!<%?%Y!<%9(B
117: $B$r=i4|2=$7!$%F%9%H%G!<%?$r:n$kI,MW$,$"$j$^$9!%(B
1.1 momjian 118:
119: $ pgbench -i [$B%G!<%?%Y!<%9L>(B]
120:
1.3 ishii 121: $B$3$l$K$h$j0J2<$N%F!<%V%k$,:n$i$l$^$9(B($B%9%1!<%j%s%0%U%!%/%?!<(B == 1 $B$N>l9g(B)$B!%(B
1.1 momjian 122:
123: $B!vCm0U!v(B
124: $BF1$8L>A0$N%F!<%V%k$,$"$k$H:o=|$5$l$F$7$^$&$N$G$4Cm0U2<$5$$!*!*(B
125:
126: $B%F!<%V%kL>(B $B%?%W%k?t(B
127: -------------------------
128: branches 1
129: tellers 10
130: accounts 100000
131: history 0
132:
1.3 ishii 133: $B%9%1!<%j%s%0%U%!%/%?!<$r(B 10,100,1000 $B$J$I$KJQ99$9$k$H!$>e5-%?%W%k?t$O(B
134: $B$=$l$K1~$8$F(B10$BG\!$(B100$BG\!$(B1000$BG\$K$J$j$^$9!%$?$H$($P!$%9%1!<%j%s%0%U%!(B
135: $B%/%?!<$r(B 10 $B$H$9$k$H!$(B
1.1 momjian 136:
137: $B%F!<%V%kL>(B $B%?%W%k?t(B
138: -------------------------
139: branches 10
140: tellers 100
141: accounts 1000000
142: history 0
143:
1.3 ishii 144: $B$K$J$j$^$9!%(B
1.1 momjian 145:
146: $B"#!V%H%i%s%6%/%7%g%s!W$NDj5A(B
147:
1.3 ishii 148: pgbench $B$G$O!$0J2<$N%7!<%1%s%9$rA4It40N;$7$F(B1$B%H%i%s%6%/%7%g%s$H?t$($F(B
149: $B$$$^$9!%(B
1.1 momjian 150:
151: (1) begin;
152:
153: (2) update accounts set abalance = abalance + :delta where aid = :aid;
1.3 ishii 154: $B$3$3$G!$(B:delta$B$O(B1$B$+$i(B1000$B$^$G$NCM$r<h$kMp?t!$(B:aid $B$O(B 1$B$+$i(B100000$B$^$G(B
155: $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(B
156: $BCf$G$OF1$8CM$r;H$$$^$9!%(B
1.1 momjian 157:
158: (3) select abalance from accounts where aid = :aid;
1.3 ishii 159: $B$3$3$G$O(B1$B7o$@$18!:w$5$l$^$9!%(B
1.1 momjian 160:
161: (4) update tellers set tbalance = tbalance + :delta where tid = :tid;
1.3 ishii 162: $B$3$3$G(B :tid $B$O(B 1$B$+$i(B10$B$N4V$NCM$r$H$kMp?t$G$9!%(B
1.1 momjian 163:
164: (5) update branches set bbalance = bbalance + :delta where bid = :bid;
1.3 ishii 165: $B$3$3$G(B :bid $B$O(B 1 $B$+$i(B[$B%9%1%j%s%0%U%!%/%?!<(B]$B$N4V$NCM$r<h$kMp?t$G$9!%(B
1.1 momjian 166:
167: (6) insert into history(tid,bid,aid,delta) values(:tid,:bid,:aid,:delta);
168:
169: (7) end;
170:
171: $B"#:n<T$H%i%$%;%s%9>r7o(B
172:
1.3 ishii 173: pgbench $B$O@P0f(B $BC#IW$K$h$C$F=q$+$l$^$7$?!%%i%$%;%s%9>r7o$O(B pgbench.c $B$N(B
174: $BKAF,$K=q$$$F$"$j$^$9!%$3$N>r7o$r<i$k8B$jL5=~$GMxMQ$7!$$^$?<+M3$K:FG[IU(B
175: $B$G$-$^$9!%(B
1.1 momjian 176:
177: $B"#2~DjMzNr(B
1.5 ! ishii 178:
! 179: 2002/02/24
! 180: * $B$3$3$+$i$O(B7.3$BMQ$NJQ99$G$9!%(B
! 181: * CHECKPOINT$B$NH/9T$r$d$a$^$7$?!%(B
! 182: * -N $B%*%W%7%g%s$rDI2C$7$^$7$?!%(B
1.4 ishii 183:
184: 2001/10/24
185: * PostgreSQL 7.2$B$G!$(B"time"$B$,M=Ls8l$K$J$C$?$N$G!$(B"mtime"$B$KJQ99(B
186: $B$7$?!%(B
1.1 momjian 187:
1.3 ishii 188: 2001/09/09
189: * PostgreSQL 7.2$BMQ$K!$(B-U, -P, -C $B%*%W%7%g%s$rDI2C$7$^$7$?!%(B
190:
191: 2000/1/15 pgbench-1.2 $B$O(B PostgreSQL $B$K(B contribute $B$5$l$^$7$?!%(B
1.1 momjian 192: * -v $B%*%W%7%g%sDI2C(B
193:
194: 1999/09/29 pgbench-1.1 $B%j%j!<%9(B
195: * $BC+ED$5$s$K$h$k(Bcygwin$BBP1~%Q%C%A<h$j9~$_(B
196: * $B%P%C%/%(%s%I%/%i%C%7%e;~$NBP1~(B
197: * -S $B%*%W%7%g%sDI2C(B
198:
199: 1999/09/04 pgbench-1.0 $B%j%j!<%9(B
PostgreSQL CVSweb <[email protected]>
![[BACK]](/https/anoncvs.postgresql.org/cvsweb/icons/back.gif){kind=icon}
Return to README.pgbench_jis CVS log ![[TXT]](/https/anoncvs.postgresql.org/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/https/anoncvs.postgresql.org/cvsweb/icons/dir.gif){kind=icon}
Up to [PostgreSQL CVS Repository] / pgsql / contrib / pgbench