<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>$BD4::D:$-$"$j$,$H$&$4$6$$$^$9!#(B</div><div>$BL532$H$$$&$3$H$G0B?4$7$^$7$?!#(B</div><div><br></div><div>$BH/@8>r7o$G3NG'$J$N$G$9$,!":G=i$NLd$$9g$o$;$K$b=q$-$^$7$?$,!"(B</div><div>$B!&(BDB$B$,%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$N#2Bf9=@.!JHsF14|!K(B</div><div>

$B!&(Bpgpool$B$G%m!<%I%P%i%s%7%s%0!"%3%M%/%7%g%s%W!<%k!"%^%9%?%9%l!<%V%b!<%I$r(Bon</div><div><br></div><div>$B!&Ev=i%9%l!<%V$G$"$C$?(BDB$B$r%^%9%?$K>:3J$7(B</div><div>$B!&Ev=i%^%9%?$G$"$C$?(BDB$B$r?7%^%9%?$r85$K%9%l!<%V$H$7$?(B</div><div>$B$3$N4D6-$K$F!"?7%9%l!<%V$N(BDB$B$K$F:#2s$HF1$8MM$K(Bpgpool$B$,H/9T$9$k(BSQL$B$,(Bpg_stat_activity$B$G(Bstate$B$,(Bactive$B$N$^$^;D$C$F$7$^$&!#!J?7%^%9%?!<B&$G$O;D$i$J$$!K(B</div>

<div><br></div><div>$B$H$$$&>u67$,H/@8$7$F$$$^$9!#!J8!>Z4D6-$G$b3NG'$7$F$$$^$9!K(B</div><div>$B$3$l$OH/@8>r7o#2$K$D$$$F5U$b5/$3$j$&$k$H9M$($F$h$m$7$$$N$G$7$g$&$+!)(B</div><div>$B$=$b$=$b(Bpgpool$B$,H/9T$9$k(BSQL$B$,%9%l!<%V$K9T$/$3$H<+BN$OLdBj$G$O$"$j$^$;$s$G$7$g$&$+!)(B</div><div><br></div><div>$B$h$m$7$/$*4j$$$7$^$9!#(B</div><div><br></div><div><br></div>

<div><div class="gmail_extra"><div class="gmail_quote">2014$BG/(B1$B7n(B31$BF|(B 18:44 Tatsuo Ishii <span dir="ltr">&lt;<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>&gt;</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>
$B%=!<%9%3!<%I$rD4$Y$?7k2L!"7kO@$H$7$F$O!VL532!W$G$9!#(B<br>
<br>
$B$3$N8=>]$,H/@8$9$k>r7o$G$9$O!"(B<br>
<br>
1) $B3HD%Ld$$9g$o$;%b!<%I(B(-M extended$B$"$j(B)<br>
<br>
2) $BF1$8%;%C%7%g%s$NCf$G!"(Bpgpool-II$B$,FbIt$GH/9T$9$k%/%(%j$,%^%9%?$KAw$i(B<br>
&nbsp; &nbsp;$B$l!"%f!<%6%/%(%j$OIi2YJ,;6$K$h$C$F%^%9%?0J30$KAw$i$l$?(B<br>
<br>
$B$N(BAND$B$G$9!#(BPostgreSQL$B$O!"(Bpg_stat_activity$B$GI=<($5$l$k%/%(%j$,(Bidle$B$K$J$k(B<br>
$B>r7o$H$7$F!"%/%i%$%"%s%H(B($B$3$N>l9g$O(Bpgool-II)$B$+$i(B&quot;sync&quot;$B$H$$$&%a%C%;!<%8(B<br>
$B$,Aw$i$l$F$/$k$3$H$J$N$G$9!#$H$3$m$,!"(Bsync$B$rAw$C$F$7$^$&$H!"(BPostgreSQL<br>
$B$,>!<j$KL5L>%]!<%?%k(B(executor$B$N%O%s%I%k$N$h$&$J$b$N(B)$B$r:o=|$7$F$7$^$$!"(B<br>
$B%f!<%6%/%(%j$,L5L>%]!<%?%k$G<B9TCf$N>l9g$K!"8eB3$N%/%(%j$,<B9T$G$-$J$/(B<br>
$B$J$C$F$7$^$$$^$9(B($B$7$g$&$,$J$$$N$G(Bpgpool-II$B$O!"(Bsync$B$NBe$o$j$K(B&quot;flush&quot;$B$H$$(B<br>
$B$&%a%C%;!<%8$rAw$k$h$&$K$7$F$$$^$9(B)$B!#(B<br>
<br>
# PostgreSQL$B$,!"%3%^%s%I$,@5>o=*N;$7$?$i!"%9%F!<%?%9$r(Bactive$B$+$i(Bidle$B$K(B<br>
# $B$7$F$/$l$l$PNI$$$N$G$9$,(B...<br>
<br>
PostgreSQL$B$N=hM}$,8=>u$N$^$^$G$"$k8B$j!":#$N$H$3$m(Bpgpool-II$BB&$G$O2sHrJ}(B<br>
$BK!$,$J$$$?$a!"L5;k$7$F$$$?$@$/$h$&$K$*4j$$$7$^$9!#(B<br>
<br>
$B99$K$46=L#$N$"$kJ}$O!"(Bsrc/backend/postmaster/postmaster.c$B!"(B<br>
src/backend/tcop/postgres.c$B$N(B3915$B9T$"$?$j(B($B9T?t$O8=;~E@$N(Bmaster branch)<br>
$B$r$4Mw$/$@$5$$!#(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>
<br>
&gt; $B@P0fMM(B<br>
&gt;<br>
&gt; $B$*@$OC$K$J$j$^$9!"Dg1J$G$9!#(B<br>
&gt;<br>
&gt; -M extended$B$J$7>l9g$OH/@8$7$^$;$s!#(B<br>
&gt; pg_stat_activity$B$G$O(Bstate$B$,(Bidle$B$K$J$C$F$$$^$9!#(B<br>
&gt; $B<B:]$KIi2Y$,$1$7$?;~$N%m%0$rE:IU$7$^$9!#(B<br>
&gt;<br>
&gt; $B$h$m$7$/$*4j$$$7$^$9!#(B<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; 2014$BG/(B1$B7n(B29$BF|(B 17:57 Tatsuo Ishii &lt;<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>&gt;:<br>
&gt;<br>
&gt;&gt; $B@P0f$G$9!#(B<br>
&gt;&gt;<br>
&gt;&gt; $B$3$N8=>]$O!"(B-M extended $B$J$7$G$bH/@8$7$^$9$+!)(B<br>
&gt;&gt; --<br>
&gt;&gt; Tatsuo Ishii<br>
&gt;&gt; SRA OSS, Inc. Japan<br>
&gt;&gt; English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
&gt;&gt; Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
&gt;&gt;<br>
&gt;&gt; &gt; $B$*@$OC$K$J$j$^$9!"Dg1J$G$9!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; $B:rG/Kv$+$iLd$$9g$o$;$5$;$F$$$?$@$F$$$k(Bpgpool$B$+$iH/9T$5$l$k(B<br>
&gt;&gt; &gt; SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid =<br>
&gt;&gt; &gt; pgpool_regclass(&#39;$B%f!<%6!<%F!<%V%k(B&#39;) AND c.relpersistence = &#39;u&#39;<br>
&gt;&gt; &gt; $B$K$D$$$F$G$9$,!"$$$m$$$m8!>Z$7$F$$$kCf$G5$$K$J$k5sF0$,M-$j$^$7$?$N$G!"$4Js9p$5$;$F$$$?$@$-$^$9!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; $B9=@.$O!"(B<br>
&gt;&gt; &gt; pgpool-ii$B!'(B: 3.3.1$B!"%^%9%?!<%9%l!<%V%b!<%I!"%m!<%I%P%i%s%9%b!<%I!"%3%M%/%7%g%s%W!<%k%b!<%I$r;HMQ(B<br>
&gt;&gt; &gt; PostgreSQL$B!'(B9.3.0$B!"%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$G%^%9%?#1Bf!"%9%l!<%V#1Bf(B<br>
&gt;&gt; &gt; $B$=$l$>$lJL%5!<%P!<$G!"(BOS$B$O(BCentOS6.4(64bit)<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; pgbench$B$r;H$C$?Ii2Y$,$1(B(-S$B!"(B-M extended)$B$r9T$C$F3NG'$7$^$7$?!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; DB1$B9f5!(B($B%^%9%?!<(B)$BB&$GIi2Y$,$1Cf$N(Bpg_stat_activity$B$r8+$k$H(B<br>
&gt;&gt; &gt; SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid =<br>
&gt;&gt; &gt; pgpool_regclass(&#39;pgbench_accounts&#39;) AND c.relpersistence = &#39;u&#39;<br>
&gt;&gt; &gt; $B$,$:!<$C$H(Bactive$B$N$^$^$G;D$C$F$$$^$7$?!#(B<br>
&gt;&gt; &gt; pgbench$B$,=*N;$9$k$H>e5-$K(BSQL$B$b$-$l$$$K>C$($F$$$^$9!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; psql$B$G(J\dx$B$G(Bpgpool_regclass$B$,F~$C$F$$$k$3$H$b3NG'$7$F$$$^$9!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; $B$^$?!"(B1$B9f5!$r%^%9%?!<$+$i%9%l!<%V$K@ZBX$r9T$C$?>l9g$G$b!"%9%l!<%V$N#19f5!$K$N$_F1MM$N8=>]$,H/@8$7$^$9!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; $B0JA0!"@P0fMM$+$i$O$3$N(BSQL$B$,%"%W%j%1!<%7%g%s$N(BSQL$BH/9TA0$K<B9T$5$l!"$=$l$,=*$o$i$J$$$H%"%W%j$N(BSQL$B$,<B9T$5$l$J$$$H$*$7$($F$$$?$@$$$?$N$G$9$,!":#2s$N8=>]$K$*$$$F!"$3$l$,5/0x$7$F%"%W%j%1!<%7%g%s$,CY$/$J$C$F$$$k$h$&$K$O8+$($^$;$s$G$7$?!#(B<br>
&gt;&gt; &gt; $B$b$H$b$H!"<B:]$K%7%9%F%`>e$K>o$K>e5-$N(BSQL$B$,(BLogTransaction$B$H$J$C$F$7$^$C$F$$$k$?$a!"JLES8!>Z4D6-$G8!>Z$r9T$$:F8=$,$G$-$^$7$?!#(B<br>
&gt;&gt; &gt; $B;29M$^$G$K!"8!>Z4D6-$G$NIi2Y$,$1;~$N%m%0$rE:IU$7$^$9!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; $B$3$N5sF0$O!"<B32$,$J$$$h$&8+$($F$$$^$9$,!"IT6q9g$G$O$J$$$G$7$g$&$+!)(B<br>
&gt;&gt; &gt; $B$b$7IT6q9g$G$"$l$P2r>C$N8!F$$b$7$F$$$?$@$1$k$H$"$j$,$?$$$G$9!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; $BD4::!"3NG'$NDx$h$m$7$/$*4j$$$7$^$9!#(B<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; --<br>
&gt;&gt;<br>
&gt;<br>
&gt;<br>
<span class="HOEnZb"><font color="#888888">&gt;<br>
&gt; --</font></span></blockquote></div></div></div></div>