<div dir="ltr">$B@P0fMM(B<div><br></div><div>$B$*@$OC$K$J$j$^$9!"Dg1J$G$9!#(B</div><div>$B$42sEzD:$-!"M-Fq$&$4$6$$$^$9!#(B</div><div><br></div><div>SQL$B$,F~$C$F$$$k>\:Y$J%m%0$O$J$$$N$G$9$,!"D9;~4V$+$+$C$F$$$k(BSQL$B$O(Bpg_statsinfo$B>e$N(BLog Transactions$B$G8+$D$1$^$7$?!#(B</div><div><br></div><div>$B$^$:$O!"(Bpgpool_regclass$B$,F~$C$F$$$k$+3NG'$7!"F~$C$F$$$J$$>l9g$OF~$l$F$b$i$&$h$&$K$7$^$9!#!J:n6H$N<B:]$O$Y$D$N$H$3$m$,9T$C$F$$$k$N$G!K(B<br>
</div><div>$B$=$N>e$G!":FH/$9$k$+8+$?$$$H;W$$$^$9!#(B</div><div><br></div><div>$B=iJbE*$J<ALd$G$9$$$^$;$s$,(Bpgpool_regclass$B$K$D$$$F(Bpgool-II$B$r(Brpm$B$G%$%s%9%H!<%k$7$?>l9g$O$I$N$h$&$K%$%s%9%H!<%k$7$?$i59$7$$$N$G$7$g$&$+!)(B</div><div>$B%=!<%9$+$i%$%s%9%H!<%k$7$?>l9g$O$o$+$k$N$G$9$,!"(BRPM$B$+$i$@$H%=!<%9$,L5$$$N$G$=$N$^$^$G$O=PMh$J$$$H;W$C$F$$$^$9!#(B</div><div>$B$^$?!"%3%s%Q%$%k<+BN$O(BpostgreSQL$B$,F~$C$F$$$k%5!<%P!<$G9T$&$N$G%"%C$F$$$^$9$G$7$g$&$+!)(B</div>
<div><br></div><div>$B$h$m$7$/$*4j$$CW$7$^$9!#(B</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013$BG/(B12$B7n(B18$BF|(B 11:02 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">$B@P0f$G$9!#(B<br>
<br>
> $BDg1J$H?=$7$^$9!#(B<br>
><br>
> pgpool-II 3.3.1$B$*$h$S(Bpostgresql9.3.0$B$r;H$$!"%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$H%m!<%I%P%i%s%7%s%0$N9=@.$rAH$s$@%7%9%F%`$K$F!"(B<br>
> $B;~4V$N$+$+$C$F$$$k(BSQL$B$rD4::$7$F$$$?$N$G$9$,!"2<5-$N$h$&$J(BSQL$B$,(B600$BIC$H$+(B500$BIC6a$/$+$+$C$F$$$k$b$N$,2?7o$+$"$j$^$7$?!#!J2a5n$K$O(B15$B;~4V$H$$$&;~$b$"$j$^$7$?!K(B<br>
><br>
> SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.relname = '$B%f!<%6!<%F!<%V%kL>(B'<br>
> AND c.relpersistence = 'u'<br>
><br>
> $B$3$A$i$N%a!<%j%s%0%j%9%H$N2a5n%m%0$J$I$G(Bpgool-II$B$,4IM}MQ$KH/9T$7$F$$$k$b$N$N$h$&$J$N$G$9$,!"4v$D$+3NG'!&<ALd$,$"$j$^$9!#(B<br>
><br>
> $B#1!%$3$N(BSQL$B$O(Bpgpool-II$B$+$iH/9T$7$F$$$k$b$N$+$I$&$+(B<br>
<br>
$B$O$$!"(Bpgpool-II$B$,H/9T$7$F$$$^$9!#(B<br>
<br>
> $B#2!%(Bpgpool-II$B$+$iH/9T$7$F$$$k>l9g!"$I$N$h$&$J%?%$%_%s%0$GH/9T$5$l$k$N$+(B<br>
<br>
$B$=$N%;%C%7%g%s$NCf$G!"!V%f!<%6!<%F!<%V%kL>!W$,:G=i$K%/%(%j$NCf$GMxMQ$5$l$k;~$G$9!#(B<br>
<br>
> $B#3!%$3$N(BSQL$B$,D9;~4V$+$+$C$F$$$k$3$H$,%"%W%j%1!<%7%g%s%7%9%F%`$X$N1F6A$O$J$$$N$+!J$[$C$F$*$$$F$$$$$b$N$+$I$&$+(B<br>
$B!K(B<br>
<br>
$B$"$j$^$9!#$3$N%/%(%j$,=*N;$7$J$$$H!"<B9T$5$l$k$O$:$@$C$?%f!<%6$N%/%(%j(B<br>
$B$b<B9T$5$l$^$;$s!#(B<br>
<br>
> $B#4!%$3$N(BSQL$B$,D9;~4V$+$+$i$J$$$h$&$K2~A1$9$kJ}K!$O$J$$$N$+(B<br>
<br>
$BDL>o$O$3$N$h$&$J$3$H$O5/$3$i$J$$$O$:$J$N$G!"%P%0$+@_Dj$NLdBj$@$H;W$o$l(B<br>
$B$^$9!#$3$N;~4V$N$+$+$C$F$$$k%/%(%j$rH/9T$7$F$$$k(Bpgpool-II$B;R%W%m%;%9$HF1(B<br>
$B$8(Bpid$B$N;R%W%m%;%9$N>/$7A0$N%m%0$,$"$l$P2?$+$o$+$k$+$b$7$l$^$;$s!#(B<br>
<br>
$B$H$3$m$G5$$K$J$k$N$O!"(Bpgpool_regclass$B$,%$%s%9%H!<%k$5$l$F$$$J$$$h$&$K8+(B<br>
$B<u$1$i$l$k$3$H$G$9!#$^$:$O(Bpgpool_regclass$B$,%$%s%9%H!<%k$7$F$/$@$5$$!#(B<br>
<br>
> $B$4B8CN$NJ}$,$*$i$l$^$7$?$i65$($F2<$5$$!#(B<br>
><br>
> $B$h$m$7$/$*4j$$$7$^$9!#(B<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>$B(#(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!($(B<br> $B3t<02q<R%"%$%F%#%U%)!<(B<br> $B;v6HK\It(B $B5;=Q4k2hIt(B $BDg1J(B $B2B;T(B<br> Mail: <a href="mailto:ksadanaga@itfor.co.jp" target="_blank">ksadanaga@itfor.co.jp</a><br>
Tel: 03-5275-7903 ($BFb@~(B: 61466)<br>$B(&(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(%(B
</div>