<div dir="ltr">$B@P0fMM(B<div><br></div><div>$B$*@$OC$K$J$j$^$9!"Dg1J$G$9!#(B</div><div><br></div><div><br></div><div>$B0l:rF|!"(Bpgpool-II$B$N%P!<%8%g%s%"%C%W$G(B</div><div>SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('$B%f!<%6!<%F!<%V%kL>(B') AND c.relpersistence = 'u'<br>
</div><div>$B$N<B9T;~4V$ND9$$(BSQL$B$H$7$F$G$J$/$J$C$F$H$*EA$($7$F$$$?$N$G$9$,!"$=$N8e?tF|$N>u67$r3NG'$7$F$_$k$H$d$O$j:GBg$G(B600$BIC6a$/$+$+$C$F$7$^$C$F$$$k$b$N$,=P$F$-$F$7$^$$$^$7$?!#(B</div><div>$BAa5^$K860xD4::$d2r>C$r$7$?$H;W$$$^$9!#(B</div><div>$BK\HV4D6-$J$N$G!"$"$^$j(BSQL$B$J$I$N%m%0$r=P$9$3$H$,$G$-$J$$$N$H!"$$$DH/@8$9$k$+$,8+$($J$$$N$G$9$,!"$I$N$h$&$J%m%0!)$d%3%^%s%I<B9T$J$I$r$9$l$PD4::$G$-$^$9$G$7$g$&$+!)(B<br>
</div><div>$B@_Dj$NLdBj$+$b$H$b0JA0$4;XE&$,$"$C$?$N$G$9$,!"@_Dj$O$I$3$"$?$j$,4XO"$7$^$9$G$7$g$&$+!)(B</div><div><br></div><div>$B4D6-$H$7$F$O!"(B</div><div><br></div><div>$B!Z(Bpgpool-II$B%5!<%P!<![!_(B2$BBf(B (Watchdog$B$G>iD92=(B)</div><div>$B!!(BOS$B!'(BCentOS6.4(64bit)</div><div>$B!!(Bpgool-II$B!'(B3.3.1 (<a href="http://pgpool.net">pgpool.net</a>$B$N(BRPM$B$+$i%$%s%9%H!<%k(B)</div>
<div>$B!!"*%m!<%I%P%i%s%5!<%b!<%I!"%l%W%j%1!<%7%g%s%b!<%I(B(SR)</div><div><br></div><div><br></div><div>$B!Z(BDB$B%5!<%P!<![!J%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s!&HsF14|(B)</div><div>$B!!(BOS$B!'(BCentOS6.4(64bit)</div><div>$B!!(BPostgreSQL$B!'(B9.3.0 (<a href="http://yum.postgresql.org/rpmchart.php">http://yum.postgresql.org/rpmchart.php</a>$B$N(BRPM$B$+$i%$%s%9%H!<%k(B)</div>
<div> $B!!!!"*(Bpgpool_regclass$B4X?tF3F~:Q$_(B</div><div><br></div><div>$B!!(Bpgpool-II$B$H(BDB$B$OJL%5!<%P!<$H$7$F(B2$BBf$:$D$G2TF/!#(B</div><div>$B$H$J$C$F$$$^$9!#(B</div><div><br></div><div>$BI,MW$J>pJs$J$I$,$"$l$*65$($$$?$@$-$?$/!#(B</div><div><br></div><div>$B59$7$/$*4j$$$$$?$7$^$9!#(B</div><div><br></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2013$BG/(B12$B7n(B24$BF|(B 14:14 $BDg1J2B;T(B <span dir="ltr"><<a href="mailto:ksadanaga@itfor.co.jp" target="_blank">ksadanaga@itfor.co.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">$B@P0fMM(B<div><br></div><div>$B$*@$OC$K$J$j$^$9!"Dg1J$G$9!#(B</div><div><br></div><div><span style="font-family:arial,sans-serif;font-size:11px">SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.relname = '$B%f!<%6!<%F!<%V%kL>(B' AND c.relpersistence = 'u'</span><br>
</div><div><font face="arial, sans-serif"><span style="font-size:11px">$B$N<B9T$K;~4V$,$+$+$C$F$$$k7o$G$9$,!"7k2L$H$7$F$O2r>C$5$l$^$7$?!#(B</span></font></div><div><font face="arial, sans-serif"><span style="font-size:11px"><br></span></font></div><div><span style="font-size:11px;font-family:arial,sans-serif">$B:G=i$K$*EA$($7$F$$$?(BPgpool-II$B$H(BPostgreSQL$B$N%P!<%8%g%s$,4V0c$C$F$$$F!"(B3.3.0$B$H(B9.3.0$B$G$7$?!#(B</span></div>
<div><font face="arial, sans-serif"><span style="font-size:11px">$B$=$N4D6-$K$F(Bpgpool-regclass$B$r%3%s%Q%$%k$7!"4X?t$r:n@.$7$?8e3NG'$7$F$_$k$H>e5-$N(BSQL$B$G;~4V$,$+$+$C$F$$$k$N$,2~A1$7$F$^$;$s$G$7$?!#(B</span></font></div><div><font face="arial, sans-serif"><span style="font-size:11px"><br>
</span></font></div><div><font face="arial, sans-serif"><span style="font-size:11px">pgpool-II$B$r(B3.3.1$B$K%"%C%W%G!<%H$7$?$H$3$m!">e5-$N(BSQL$B$G;~4V$,$+$+$C$F$$$k8=>]$O2r>C$5$l$^$;$s$G$7$?!#(B</span></font></div><div><font face="arial, sans-serif"><span style="font-size:11px"><br>
</span></font></div><div><font face="arial, sans-serif"><span style="font-size:11px">$B$4;XF3$$$?$@$-$^$7$F!"$"$j$,$H$&$4$6$$$^$7$?!#(B</span></font></div><div><br></div><div class="gmail_extra"><div class="gmail_quote">2013$BG/(B12$B7n(B18$BF|(B 16:44 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:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">$B@P0f$G$9!#(B<br>
<br>
> $B@P0fMM(B<br>
><br>
> $B$*@$OC$K$J$j$^$9!"Dg1J$G$9!#(B<br>
> $B$42sEzD:$-!"M-Fq$&$4$6$$$^$9!#(B<br>
><br>
> 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<br>
><br>
> $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>
> $B$=$N>e$G!":FH/$9$k$+8+$?$$$H;W$$$^$9!#(B<br>
><br>
> $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<br>
> $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<br>
<br>
RPM$B$K$h$j$^$9$,!"(B<a href="http://www.pgpool.net/" target="_blank">http://www.pgpool.net/</a> $B$GG[I[$7$F$$$k$b$N$O(B<br>
pgpool_regclass$B$,F~$C$F$$$^$9!#$=$l0J30$N(BRPM$B$O4XCN$7$F$$$J$$$N$GNI$/$o(B<br>
$B$+$j$^$;$s!#(B<br>
<br>
> $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<br>
<br>
$B$O$$!"$=$&$G$9!#(BPostgreSQL$BMQ$N4X?t$G$9$N$G!#(B<span class=""><font color="#888888"><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>
</font></span></blockquote></div><br><div><br></div></div></div>
</blockquote></div><br><div><br></div></div></div>