=?iso-2022-jp?b?W3BncG9vbC1nZW5lcmFsLWpwOiA0NTddICAbJEItNiRHJE4b?= =?iso-2022-jp?b?KEIoQkRCGyRCJSIlLyU7JTlALUc9JEskRCQkJEYbKEI=?=

[Yoshiyuki Asaba]

$B ＠ u1)$G$9!#(B

From: TONAGI Masao <tonagi ＠ kke.co.jp>
Subject: [pgpool-general-jp: 455] $B-6$G$N(B(BDB$B%"%/%;%9 ＠ -G=$K$D$$$F(B
Date: Mon, 16 Jun 2008 16:23:12 +0900

> $B8=:_!"(Btomcat$B>e$K:\$;$?(Bjava$B$N(Bweb$B%"%W%j$K$D$$$F!"(Bpgpool$B-6$r(B
> $B;H$C$F!"(BpostgreSQL$B$K@\B3$9$k%7%9%F%`$N8!>Z$r9T$C$F$*$j$^$9!#(B
> $B$=$NCf$N8!>Z7k2L$K$D$$$F5?LdE@$"$j!"Ej9F$5$;$FD:$-$^$7$?!#(B
> 
> $B!c5?LdE@!d(B
> $B8!>Z$NCf$G!"(BpostgreSQL$B$r$N$;$?(BDB$B%5!<%P$r(B2$BBf$K$9$k$H!"(BDB$B%5!<%P(B
> 1$BBf$N;~$KHf$Y ＠ -G=$,Ls(B1/2$B$K$J$k8!>Z7k2L$H$J$C$F$7$^$&!#(B

JDBC $B%I%i%$%P$N5sF0$r$h$/3P$($F$$$J$$$N$G$b$7$4B8CN$G$"$l$P65$($F$/$@(B
$B$5$$!#(BsetAutoCommit() $B$r<B9T$7$J$+$C$?>l9g!"FbItE*$K(B BEGIN $B$,H/9T$5$l(B
$B$k$N$G$7$g$&$+!)(B

$B$b$7$=$&$@$H$9$k$H!"%H%i%s%6%/%7%g%s%V%m%C%/Fb$KF~$C$F$7$^$&$?$a!"%m!<(B
$B%I%P%i%s%9$,8z$+$J$/$J$j$^$9!#$?$@!"$=$l$G$b(B 1/2 $B$K$J$k$3$H$O9M$($K$/(B
$B$$$N$G!"(B2 $BBf$N%5!<%P$G(B postgresql.conf $B$N(B log_statement $B$rM-8z$K$7$F$$(B
$B$?$@$-!"$I$N$h$&$J%/%(%j$,H/9T$5$l$F$$$k$+$43NG'$/$@$5$$!#(B

$B$h$m$7$/$*4j$$$7$^$9!#(B
--
Yoshiyuki Asaba
y-asaba ＠ sraoss.co.jp



> 
> $B8!>ZMQ$K8!:w$N$_$N(Bjava$B%"%W%j$r:n ＠ .$7$FF0:n$5$;$F$_$^$7$?$,!"(B
> $B>e5-(BDB$B%5!<%P(B2$BBf$N>l9g$K(B1$BBf$KHf$Y ＠ -G=$,Nt2=$9$k;v>]H/@8CW$7$^$7$?!#(B
> $B!J(BDB$B%5!<%P(B2$BBf$G$"$l$P!"FC$K8!:w$N$_$N=hM}$G$"$l$P!"=hM}@-G=$,(B
> $B8~>e$9$k$b$N$H;W$C$F$*$j$^$9!K(B
> 
> $B ＠ _Dj8m$j$r5?$C$F$$$^$9$,!"$I$&$7$F$b2r7h$G$-$J$$$G$*$j$^$9!#(B
> $B;v>]$N3NG'J}K!$d!"2r7h:vEy!"%"%I%P%$%9Ey$4$6$$$^$;$s$G$7$g$&$+!#(B
> 
> $B8!>Z$KMQ$$$F$$$k(BMW$B9=@.$d$3$A$i$G$N8!>Z$N35MW$J$I!"(B
> $B0J2<$NDL$j$H$J$j$^$9!#(B
> +++++
> $B!c(BMW$B9=@.!d(B
> 1)apache(2.2)+tomcat(5.5)
> 2)pgpool$B-6(B(1.3)
> 3)postgreSQL(8.2)
> $B"((BWeb$B%5!<%P!"(BDB$B%5!<%P$r(B2$BBf$E$DMQ0U!"(Bapache,tomcat,pgpool$B$r(B
> $B!!(BWeb$B%5!<%P$G!"(BpostgreSQL$B$r(BDB$B%5!<%P$GF0:n$5$;$F$$$^$9!#(B
> 
> $B!c(Bjava$B4XO"!d(B
> 1)java(jdk1.5)
> 2)postgresql-8.2-505.jdbc3
> 
> $B!c(Bpgpool$B-6 ＠ _Dj!d(B
> $B"(K\%a!<%k$K(Bpgpool.conf$B$rE:IUCW$7$^$9!#(B
> 
> $B!cHw9M!d(B
> $B$3$A$i$G8!>Z$7$?35MW$K$D$$$F!"0J2<$K5-$7$^$9!#(B
> $B8!>Z(B1)$B8!:w$N$_$N(Bjava$B%5!<%V%l%C%H$r:n ＠ .$7!"@-G=B,Dj$r<B;\(B
> $B!!"*7k2L!((BDB$B%5!<%P(B2$BBf$r;HMQ$7$?:]!"@-G=$,(BDB1$BBf$KHf$YH>J,$KMn$A$k!#(B
> 
> $B8!>Z(B2)$B8!>Z(B1$B$H$[$\F1$8=hM}$r$9$k(Bphp$B%"%W%j$r:n ＠ .$7!"(Bapache$B>e$G(B
> $B!!F0:n3NG'$r<B;\$9$k!#(B
> $B!!"*7k2L!((BDB$B%5!<%P(B2$BBf$N;~$NJ}$,!"(BDB$B%5!<%P(B1$BBf$KHf$Y!"Ls(B1.1$BG\$N(B
> $B!!!!@-G=8~>e$,$_$i$l$k!#(B
> $B!!"(8!>Z$KMxMQ$7$?(Bphp$B%U%!%$%k$rE:IUCW$7$^$9(B(dbtest4.php)$B!#(B
> 
> $B8!>Z(B3)$B8!>Z(B1$B$HF1$8$h$&$J=hM}$r$9$k(Bjava$B%"%W%j$rMQ0U$7F0:n3NG'$r<B;\$9$k!#(B
> $B!!"*7k2L!(8!>Z(B1$B$HF1MM$K!"(BDB$B%5!<%P(B2$BBf$r;HMQ$7$?:]!"@-G=$,(BDB1$BBf$K(B
> $B!!!!Hf$YH>J,$KMn$A$k!#(B
> $B!!"(8!>Z$KMxMQ$7$?(Bjava$B%U%!%$%k!J$*$h$S(Bjava$B$r%-%C%/$9$k%7%'%k(B)$B$r(B
> $B!!!!E:IUCW$7$^$9(B(DatabaseTest8.java$B!"(Bdbtest8.sh$B!K!#(B
> 
> $B8!>Z(B2,3$B$G$O!"(BpostgreSQL$B$K$"$k(Bpgbench$B$K$F:n ＠ .$5$l$k(BDB$B!J%F!<%V%k!K$K(B
> $B%"%/%;%9$7$FF0:n3NG'$r$7$F$*$j$^$9!#(B
> +++++
> 
> $BD9J8$H$J$j?=$7Lu$"$j$^$;$s!#0J>e!"$h$m$7$/$*4j$$CW$7$^$9!#(B
> 
> ----------
> TONAGI Masao(tonagi ＠ kke.co.jp)