[pgpool-general-jp: 524] Re: pg_pool2について

Tatsuo Ishii ishii @ sraoss.co.jp
2009年 1月 8日 (木) 20:01:04 JST


$B @ P0f$G$9!%K\G/$b$h$m$7$/$*4j$$$7$^$9!%(B

> $B @ hF|!"%a!<%k$5$;$F$$$?$@$$$?EgE{$G$9!#(B
> 
> $BK\G/$b$h$m$7$/$*4j$$$7$^$9!#(B
> 
> $B0JA0$K$b<ALd$5$;$F$$$?$@$-$^$7$?$,!"(Bpg_pool2$B$N%P!<%8%g%s$K8m(B
> $B$j$,$4$6$$$^$7$?$N$G!":FEY$4<ALd$5$;$F$$$?$@$-$^$9!#(B
> 
> $B3F%5!<%P4V$N%l%3!<%I$K:90[$,H/@8$7$?8=>]$,3NG'$5$l$?$b$N$O!"(B
> $B%P!<%8%g%s(B 2.1-beta2$B$r;HMQ$7$F$*$j$^$7$?!#(B
> 
> $B2~$a$F<ALd$5$;$F$$$?$@$-$^$9$,!"(Bpg_pool2$B$, @ 5>o$K5/F0$7$F$$$k(B
> $B$K$b$+$+$o$i$:!"99?77O%/%(%j$,A4$F$N%5!<%P$KH?1G$5$l$J$$2DG=(B
> $B @ -$O$4$6$$$^$9$G$7$g$&$+!#(B

$B2?$+$N860x$G=LB`$,H/@8$7!$$=$l$K5$IU$+$:(Bpgpool$B$r$7$P$i$/;H$C$F$$$F!$$=(B
$B$N8e(Bpgpool$B$r:F5/F0$7$?!$$H$$$&2DG=@-$b$"$k$H;W$$$^$9$,!$G!2?$G$7$g$&$+!)(B

$B$=$&$G$J$$$H$9$k$H!$$"$H$O!$%l%3!<%I7o?t$,0[$J$k$H$$$&$3$H$O!$(B

- $B$I$A$i$+$N%N!<%I$G(BINSERT$B$,<B9T$5$l$F$$$J$$$3$H$,$"$C$?(B
- $B$I$A$i$+$N%N!<%I$G(BDELETE$B$,<B9T$5$l$F$$$J$$$3$H$,$"$C$?(B

$B$N$I$A$i$+$K$J$k$H;W$$$^$9!%$?$@!$$3$N>l9g$O(Bpgpool$B$+(BPostgreSQL$B$N%m%0$K(B
$B2?$+=q$+$l$F$$$k$O$:$G$9$,!$$=$NE@$O$$$+$,$G$7$g$&$+!)(B
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> $B0J>e(B
> 
> On Wed, 24 Dec 2008 18:41:32 +0900
> $BEgE{(B $B9LJ?(B <k.shimadutsu @ 4qualia.co.jp> wrote:
> 
> > 
> > $B @ P0fMM(B
> > 
> > $BEgE{$G$9!#(B
> > 
> > $BAa5^$J$42sEz$"$j$,$H$&$4$6$$$^$9!#(B
> > $B4pK\E*$K$"$k%5!<%P$N0l$D$G%(%i!<$,H/@8$7!":90[$,H/@8$9$k$h$&(B
> > $B$J>u67$K$J$k$H @ Z$jN%$5$l$k$3$H$H$$$&$3$H$GG'<1$$$?$7$^$7$?!#(B
> > 
> > $B @ P0fMM$h$j<ALd$$$?$@$$$?E@$K$D$$$F$O!"0J2<$K2sEz$5$;$F$$$?$@(B
> > $B$-$^$7$?!#(B
> > 
> > > $B$=$&;W$o$l$?M}M3$r6qBNE*$K65$($FD:$1$^$9$+!)(B
> > 
> > PostgreSQL$B$N%m%0$K%(%i!<$,H/@8$7$F$$$J$$$N$K!"%5!<%P4V$N%l%3(B
> > $B!<%I7o?t$K:90[$,$"$C$?$3$H(B
> > $B$^$?!"0J2<$N$h$&$J(BSQL$B$r%W%m%0%i%`$+$i<B9T$7$F$$$k$N$G$9$,!"(B
> > $B3F%5!<%P$r3NG'$9$k$H%l%3!<%I$,B8:_$7$J$$%5!<%P$,8+$D$+$C$?$3$H(B
> > 
> > CREATE TABLE table_a
> > (
> > user_id int not null,
> > item_id int not null,
> > regist_date timestamp without time zone not null,
> > PRIMARY KEY (user_id ,item_id)
> > )
> > 
> > INSERT INTO table_a ( user_id ,item_id regist_date )
> > VALUES ( 1 ,1 ,'2008-12-22 00:05:00' );
> > 
> > $B>e5-$K$D$$$F!"%"%I%P%$%9$dD4::J}K!Ey$4$6$$$^$7$?$i!"$465<x$$$?(B
> > $B$@$1$l$P$H;W$$$^$9!#(B
> > 
> > 
> > $B0J>e(B
> > 
> > On Tue, 23 Dec 2008 21:56:13 +0900 (JST)
> > Tatsuo Ishii <ishii @ sraoss.co.jp> wrote:
> > 
> > > $B @ P0f$G$9!%(B
> > > 
> > > > $B$O$8$a$^$7$F!"EgE{$H?=$7$^$9!#(B
> > > > 
> > > > $B8=:_(Bpgpool2$B$r;HMQ$7$F$*$j!"(BDB$B%5!<%P$r(B4$BBf=`Hw$7$F$$$k$N$G$9$,!"(B
> > > > $B5)$K%5!<%P4V$N%l%3!<%I?t$K:90[$, @ 8$8$F$7$^$&8=>]$,H/@8$$$?$7(B
> > > > $B$^$7$?!#(B
> > > > $B7k2L$r8+$k$H!"(BINSERT$B$N=hM}$,ESCf$G3F%5!<%P$K<B9T$5$l$kESCf$G(B
> > > > $B;_$^$C$F$$$k$h$&$K;W$o$l$^$9!#(B
> > > 
> > > $B$=$&;W$o$l$?M}M3$r6qBNE*$K65$($FD:$1$^$9$+!)(B
> > > 
> > > > $B0J2<(B3$BE@!"ITL@$JE@$,$"$j!"<ALd$5$;$F$$$?$@$-$^$9!#(B
> > > > 
> > > > $B-!(Bpgpool$B$,=hM}Cf$K(B1$B$D$N%5!<%P$KBP$7%(%i!<$,H/@8$7$?>l9g$K$O!"(B
> > > > $B!!(Bpgpool2$B$,<B9T$7$?B>$N=hM}$r%m!<%k%P%C%/$5$l$k!#(B
> > > > $B!!$3$A$i$NG'<1$K4V0c$$$O$4$6$$$^$;$s$G$7$g$&$+!#(B
> > > 
> > > SQL$B$N<B9T%(%i!<$K$J$k>l9g$O!$7k2L$H$7$F$=$&$J$j$^$9(B($BF1$8%(%i!<%/%(%j$,(B
> > > $BAw?.$5$l$k$?$a(B)$B!%(B
> > > 
> > > $B$=$&$G$O$J$/$F!$$?$^$?$^$"$k%5!<%P$@$1$,%(%i!<$r5/$7!$B>$N%5!<%P$O @ 5>o(B
> > > $B$K%3%_%C%H$5$l$?>l9g$O!$%m!<%k%P%C%/$9$k$N$G$O$J$/!$%(%i!<$r5/$7$?%5!<(B
> > > $B%P$r @ Z$jN%$9$3$H$K$h$C$F!$A4BN$H$7$F @ 09g@-$rJ]$D$N$,(Bpgpool-II$B$NJ}?K$G(B
> > > $B$9!%(B
> > > 
> > > > $B-"(BWEB$B%5!<%PB&$+$i(Bpgpool$B$X$N%3%M%/%7%g%s$,6/@)E*$K @ ZCG$5$l$?(B
> > > > $B!!>l9g$J$I%m!<%k%P%C%/$5$l$J$$2DG=@-$O$4$6$$$^$9$G$7$g$&$+!#(B
> > > 
> > > $B$J$$$H;W$$$^$9!%(B
> > > 
> > > > $B-#>e5-0J30$K!"(Bpgpool$B$, @ 5>o$K5/F0$7$F$$$k$K$b$+$+$o$i$:!"99?7(B
> > > > $B!!7O%/%(%j$,A4$F$N%5!<%P$KH?1G$5$l$J$$2DG=@-$O$"$j$^$9$G$7$g(B
> > > > $B!!$&$+!#(B
> > > 
> > > $B$*;H$$$N%P!<%8%g%s$O8E$$$N$G!$%P%0$KAx6x$7$F$$$k2DG=@-$O$"$k$H;W$$$^$9!%(B
> > > 
> > > $B$"$H!$:G?7$N%P!<%8%g%s$G$b!$%H%i%s%6%/%7%g%s$NJ,N%%l%Y%k$K(BSERIALIZABLE
> > > $B$r;H$C$F$$$k:]$KLdBj$,5/$-$k2DG=@-$,$"$j$^$9(B($B<!$N%P!<%8%g%s$G=$@5M=Dj(B)$B!%(B
> > > 
> > > > $B4D6-$H$7$F$O!"(BWEB(PHP)+DB(pgpool2,postgres)4$BBf$N9=@.$H$J$C$F(B
> > > > $B$*$j!"0J2<$N$h$&$J%P!<%8%g%s$r;HMQ$7$F$*$j$^$9!#(B
> > > > $B$J$*!"(BNOW()$B4X?t$H(Bserial$B7?$N%+%i%`$O<BAu$7$F$*$j$^$;$s!#(B
> > > 
> > > $B<!$N%P!<%8%g%s$G$O!$(BSERIAL$B7?$b;H$($k$h$&$K$J$kM=Dj$G$9!%(B
> > > 
> > > now()$B$O(B...$B9M$(Cf(B:-)
> > > --
> > > Tatsuo Ishii
> > > SRA OSS, Inc. Japan
> > > 
> > > > $B4D6-(B
> > > > WEB
> > > > $B!!(BPHP$B%P!<%8%g%s(B $B!!!!(B5.2$B7O(B
> > > > $B!!(BApache$B%P!<%8%g%s!!(B2.0$B7O(B
> > > > $B!!(BOS$B!!!!!!!!!!!!!!!!(BFedora Core 3
> > > > 
> > > > DB
> > > > $B!!(Bpgpool$B%P!<%8%g%s!!(B2.0.1
> > > > $B!!%5!<%PBf?t!!!!!!!!(B4$BBf(B
> > > > $B!!(BOS$B!!!!!!!!!!!!!!!!(BFedora Core 3
> > > > $B!!(BDB$B%P!<%8%g%s!!!!!!(BPostgres 8.2.4
> > > > 
> > > > $B"((BApache$B$N%m%0%m!<%F%$%H$N;~4V$O(B0$B;~$G!"%m!<%F%$%H$N%?%$%_%s%0(B
> > > > $B!!$G(BKill Hup$B%3%^%s%I$,<B9T$5$l$F$$$^$9!#(B
> > > > 
> > > > $B2?B4!"$h$m$7$/$*4j$$$7$^$9!#(B
> > > > 
> > > > 
> > > > $B0J>e(B
> > > > 
> > > > $B""(#(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!($"#(B
> > > > $B(#(%!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(&($(B
> > > > $B!C!!3t<02q<R%U%)!<!&%/%*%j%"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > $B!C!!!!!!EgE{!!9LJ?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > $B!C!!")(B141-0031$B!!El5~ETIJ @ n6h@>8^H?ED(B8-3-16 $B%@%t%#%s%A@>8^H?ED-6(B7F $B!C(B
> > > > $B!C!!(BTEL: 03-5759-0292  FAX: 03-5759-0293$B!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > $B(&($(Bhttp://www.4qualia.co.jp/ $B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(#(%(B
> > > > $B"#(&(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(%""(B
> > > > 
> > 
> > $B""(#(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!($"#(B
> > $B(#(%!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(&($(B
> > $B!C!!3t<02q<R%U%)!<!&%/%*%j%"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > $B!C!!!!!!EgE{!!9LJ?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > $B!C!!")(B141-0031$B!!El5~ETIJ @ n6h@>8^H?ED(B8-3-16 $B%@%t%#%s%A@>8^H?ED-6(B7F $B!C(B
> > $B!C!!(BTEL: 03-5759-0292  FAX: 03-5759-0293$B!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > $B(&($(Bhttp://www.4qualia.co.jp/ $B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(#(%(B
> > $B"#(&(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(%""(B
> > 
> 
> $B""(#(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!($"#(B
> $B(#(%OB!zI.;&!!%G%3$j?M!!!A<c<T$h!"F|K\$N$?$a$K%a!<%k$r;H$(!*!A!!(&($(B
> $B!C!!!!!!(Bhttp://decori.4qualia.co.jp/$B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B!C!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B!C!!3t<02q<R%U%)!<!&%/%*%j%"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B!C!!!!!!EgE{!!9LJ?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B!C!!")(B141-0031$B!!El5~ETIJ @ n6h@>8^H?ED(B8-3-16 $B%@%t%#%s%A@>8^H?ED-6(B7F $B!C(B
> $B!C!!(BTEL: 03-5759-0292  FAX: 03-5759-0293$B!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B(&($(Bhttp://www.4qualia.co.jp/ $B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(#(%(B
> $B"#(&(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(%""(B
> 


pgpool-general-jp メーリングリストの案内