[pgpool-general-jp: 115] Re: 拡張問い合わせプロトコルの負荷分散パッチ

[Yoshiyuki Asaba]

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

From: $B5FCO(B $BM[2p(B <kiku_suke7788 ＠ hotmail.com>
Subject: [pgpool-general-jp: 114] Re: $B3HD%Ld$$9g$o$;%W%m%H%3%k$NIi2YJ,;6%Q%C%A(B
Date: Mon, 16 Apr 2007 21:52:12 +0900

> $B!!(BPGPool3.1.2$B!"(BPGPool3.2.0$B!"(BPGPool$B-6$G;n$7$F$_$?$N$G$9$,!"(B
> $B!!!V(BSELECT$B!W$OJ,;6$5$l$^$;$s$G$7$?!#!#!J(Bpsql$B>e$G$OJ,;6$5$l$^$9!#!K(B
> 
> $B!!(Bignore_leading_whitespace$B$b(Btrue$B$K$7$F$_$^$7$?$,!"F1$8$G$7$?$N$G4D6-$KLdBj(B
> $B$"$k$N$G$7$g$&$+(B?
> $B!!(BPostgres$B!'(B8.0.8$B!!(BJDBC$B!'(Bpostgresql-8.0-318.jdbc3.jar$B!!(BJDK$B!'(B1.4.2
> $B!!$=$l$H$b!"(Breplication_mode$B$H(Bload_balance_mode$B$r(Btrue$B$K$9$k0J30$K ＠ _Dj$,I,MW(B
> $B$G$7$g$&$+(B?

postgresql.conf $B$K(B log_statement = 'all' $B$r ＠ _Dj$7$F!"F1$8$h$&$J4D6-$G(B
$B;n$7$F$_$^$7$?!#3N$+$KN>J}$N%m%0$K(B

  LOG:  statement: select $1, $2

$B$H$$$&$h$&$J%m%0$,;D$C$F$$$^$9$,!"%G%P%C%,>e$G(B pgpool $B$rF0$+$7$F$_$k$H(B
$BJRJ}$K$7$+Aw?.$7$F$$$^$;$s$G$7$?(B($B%m!<%I%P%i%s%9$5$l$F$$$k(B)$B!#(B

$B$G$O!"$J$<>e5-%m%0$,N>J}$K=P$F$$$k$+$rD4$Y$F$_$^$7$?!#(BJDBC $B%I%i%$%P$G(B
$B$O(B

  Parse (SQL $B$N(B PREPARE $BJ8$N$h$&$J=hM}(B)
  Bind
  Describe
  Execute (SQL $B$N(B EXECUTE $BJ8$N$h$&$J=hM}(B)

$B$H$$$&%a%C%;!<%8$rAw?.$7$^$9!#(BParse $B$rAw?.$9$k$H(B PostgreSQL 8.0.x $B$G$O(B
$B>e5-%m%0$r=PNO$5$;$k$h$&$G$9!#(Bpgpool $B$G$O(B Parse, Bind, Describe $B$rN>J}(B
$B$KAw?.$7!"(BExecute $B$@$12DG=$G$"$l$PIi2YJ,;6$5$;$k$h$&$K$7$F$$$^$9!#$=$N(B
$B$?$a!"(B"select ..." $B$H$$$&%m%0$,N>J}$K;D$C$F$7$^$C$?$h$&$G$9!#(B

PostgreSQL 8.1 $B0J9_$G$O%m%0$N=PNO$,$+$o$C$?$N$G!"(B

  LOG:  execute <unnamed>: select $1, $2

$B$H$$$&%m%0$,JRJ}$K$N$_;D$C$F$$$l$PIi2YJ,;6$5$l$F$$$^$9!#(B

--
Yoshiyuki Asaba
y-asaba ＠ sraoss.co.jp