[pgsql-jp: 41638] V8.4 から V9.3 変更時にJDBCアプリがスローダウン

[Masahide Oida]

$BF|K\(BIBM $B<oED$H?=$7$^$9(B

$B8=9T4D6-$G2TF/Cf$N(BJava$B%"%W%j!J(BJDBC$B7PM3$G(BPostgreSQL$BMxMQ(B/$B%P%C%A$G(B java.exe
class$BL>(B $B$G<B9T!K$r!"(B
OS/DBMS$B$r99?7$7$??74D6-$K$=$N$^$^C1=c%3%T!<$7$?0\9T$r9M$($F$*$j$^$9!'(B

$B!Z8=9T4D6-![(B
$B!!!&%5!<%P!'(BVMWare$B2>A[%5!<%P(B $B2>A[(B4core/4GB$B%a%b%j(B
$B!!!&(BOS$B!'(BWin2008$B!J(B32bit$B!"(BR2$B$G$OL5$$!K(B
$B!!!!%"%W%j%1!<%7%g%s%5!<%P!'(BApache 2.2.22+Tomcat6.0.29
$B!!!!(BDBMS$B!'(BPostgreSQL 8.4(32bit)
$B!!!!!!!!!!(BJDBC$B%I%i%$%P!J(Bv8$BMQ!K(B postgresql-8.1-407.jdbc3.jar
$B!!!!(BJava$B!'(B6u32

$B!Z?74D6-![(BOS/DBMS$B$r99?7(B
$B!!!&%5!<%P!'(BVMWare$B2>A[%5!<%P(B $B2>A[(B8core/16GB$B%a%b%j(B
$B!!!&(BOS$B!'(BWin2012$B!J(B64bit$B!K(B
$B!!!!%"%W%j%1!<%7%g%s%5!<%P!'(BApache 2.2.25+Tomcat6.0.29
$B!!!!(BDBMS$B!'(BPostgreSQL 9.3(64bit)
$B!!!!!!!!!!(BJDBC$B%I%i%$%P!J(Bv9$BMQ!K(Bpostgresql-9.3-1100.jdbc4.jar
$B!!!!!!!!!!(BDB$B0\9T$O(B pg_dumpall $B$r8=9T$G<hF@$7!"(Bpg_restore$B$7$F%^%$%0%l!<%7%g(B
$B%s(B
$B!!!!(BJava$B!'(B6u32

$B!!"((BJDBC$B%I%i%$%P$O(BOS$B4D6-JQ?t(B CLASSPATH $B$G;HMQ%I%i%$%P(B jar $B%U%!%$%k$r;XDj(B


$B?74D6-$G$=$N$^$^%"%W%j$O2TF0$9$k$N$G$9$,!"(BSQL$B<B9T;~4V$,0[>o$KCY$/$J$C$F$7$^(B
$B$$$^$7$?!#(B
$B!J0lO"$N(BSQL$B=hM}$,8=9T4D6-$G(B40$BJ,DxEY$NJ*$,(B10$B;~4V$/$i$$!K(B

$B%"%W%j<B9TA0$K(Bvacuum$B!J(Banalyze $B%*%W%7%g%sIU!K$O<B9T$7$F$$$^$9!#(B
$BC1=c$K8=9T!&?7$NN>J}$N(BPostgreSQL$B$G(B pgbench$B!J%/%i%$%"%s%H?t(B 1 $B%H%i%s%6%/%7%g(B
$B%s?t(B 100$B!K$r(B
$B<B9T$7$FFC$KBg$-$J:90[$OL5$$$N$G(B JDBC$B7PM3(B $B$N(BSQL$B=hM}$,CY$$$N$+$H9M$($F$$$^(B
$B$9!#(B

pgbench$B7k2L!'(B
 $B!Z8=9T4D6-![(B
 number of clients: 1
 number of transactions per client: 100
 tps = 400.000000 (including connections establishing) tps = 456.621005
 (excluding connections establishing)
 $B!Z?74D6-![(B
 number of clients: 1
 number of threads: 1
 number of transactions per client: 100
 tps = 400.088746 (including connections establishing) tps = 441.638205
 (excluding connections establishing)

$B0J2<$r9T$&$H<B9T;~4V$O85$NDL$j2~A1$7$^$9!#(B
$B!!-!(B $B?74D6-$N(BDB$B$r8=9T4D6-$HF1$8(B PostgreSQL V8.4 (32bit) $B$KLa$9(B
$B!!-"(B $B?74D6-$N(BDB$B$r(B PostgreSQL 9.3 $B$K$9$k$,(B 64bit $B$G$OL5$/!"(B32bit $B$K$9$k!J(BJDBC
$B%I%i%$%PMQ(B jar $B$OF1$8$b$N$r;HMQ!K(B

$B$^$??74D6-$G0J2<<B;\$7$^$7$?$,FC$K2~A1$7$^$;$s$G$7$?(B
$B!!-#(B $B%Q%i%a!<%?JQ99!J0J2<%G%U%)%k%H$+$iJQ99$7$F<B;\!K(B
$B!!!!!!!!(Bshared_buffers = 3GB
$B!!!!!!(B? work_mem = 32MB
?$B!!!!!!(B wal_buffers = 96MB
$B!!!!!!(B? checkpoint_segments = 16
$B!!!!!!(B? random_page_cost = 3.0
$B!!!!!!(B? effective_cache_size = 3GB
$B!!-$(B JVM$B%Q%i%a!<%?(B $B$G%R!<%W$rA}2C$5$;$F<B9T(B
$B!!-%(B JDBC$B%I%i%$%P(B jar $B$r3HD%;R(B jdbc4 $B"*(B jdbc3 $B$NJ*$KJQ99$7$F<B9T(B


$B0[>o$KCY$/$J$k860x$K$D$$$F(BDB$B$r(B64bit$B$K$7$?;v$,9M$($i$l$k$N$G$9$,!"(B
$BLdBj$N ＠ Z$jJ,$1!&D4::J}K!$K$D$$$F!"$465<(D:$1$l$P9,$$$G$9(B

$B$h$m$7$/$*4j$$CW$7$^$9(B

-------------------------------------------------
$B<oED!!>-1Q(B
Masahide OIDA,  IBM Japan
$B%o!<%/%W%l!<%9!%%7%9%F%`#x%5!<%S%9!J(B6JC25$B!K(B
mobile:080-6706-1731  JTAS-SE$B ＠ J(B 042-354-4488