鹿角 浩司
kazun****@nttco*****
2018年 8月 27日 (月) 10:26:35 JST
$BF|8~$NBe9T$G2sEzCW$7$^$9!#(B
$B</3Q$G$9!#(B
$BJV?.$,CY$/$J$C$?;v$r$*OM$S$7$^$9!#(B
$B3NG'7k2L$r%$%s%i%$%s!J!z!K$GO"MmCW$7$^$9!#(B
$B!!"(!!E:IU>pJs!'%7!<%H!VD4::7k2L!W$r;2>H4j$$$^$9!#(B
$B"("(!!Ld9g$;$NJ]B8=q8K$NFbMF$,!"J8;z2=$1$7$?$N$GE:IU%U%!%$%k$J$7$G(B
$B!!!!JVEz$5$l$FD:$-$^$9!#(B
>> $B!Z<ALd;v9`![(B
>> $B!&(BML$B$K$4;22C$N3'MM$G$O!"2?$+$3$l$K4X$9$k>pJs$rGD0.$5$l$F$$$^$9$G$7$g$&$+!#(B
>> $B!&$b$7%P%0Ey$,860x$G(BFIX$B$5$l$F$$$k$H$7$?$i$=$l$O$I$N%P!<%8%g%s$G$7$g$&$+!#(B
>
>$B$^$:!"(Bpaths == "..."$B$r(Bpaths @ "..."$B$K$7$F$_$F$/$@$5$$!#(B
>$B$3$l$G8!:w7k2L$, ＠ 5$7$/$J$k$3$H$r4|BT$7$F$$$^$9!#(B
>$B!JB.EY$O$=$s$J$KJQ$o$i$J$$$+CY$/$J$k$H;W$$$^$9!#!K(B
$B!z#1(B
$B8!:w7k2L$O ＠ 5$7$$FbMF$,F@$i$l$?$,!"(BExecution time$B!J<B9T;~4V!K$K$D$$$F$O2~A18z2L$,8+$i$l$:(B
$BCY$$7k2L$H$J$C$?!#(B
>$B8!:w7k2L$, ＠ 5$7$/$J$C$?$i!"(Bwork_mem$B$rA}$d$7$F$_$F$/$@$5$$!#(B
>$B$3$l$G8!:wB.EY$b2~A1$9$k$H;W$$$^$9!#(B
$B!z#2(B
$B!V(Bwork_mem$B!W$r%G%U%)%k%H$N!V(B2MB$B!W$+$i!V(B8MB$B!W$KJQ99$7$?$H$3$m$G!"(B
Execution time$B!J<B9T;~4V!K$,Bg$-$/8:>/$9$k7k2L$,8+$i$l!"(B
$B ＠ -G=$,2~A1$9$k$3$H$,J,$+$C$?!#(B
>$B>r7o$,(B1$B$D$N%1!<%9$G$O<!$N$h$&$K(Blossy$B$,$G$F$$$^$9$,!"$3$l$O%R%C(B
>$B%H$7$?%l%3!<%I$rI=8=$9$k==J,$JBg$-$5$N%S%C%H%^%C%W$rMQ0U$G$-(B
>$B$J$$$H$-$K$G$^$9!#$3$l$,$G$k$H%7!<%1%s%7%c%k%9%-%c%s$b$7$J$/(B
>$B$F$O$J$/$J$jCY$/$J$k$s$G$9!#(Bwork_mem$B$r==J,$J%5%$%:$K$9$k$H(B
>lossy$B$,$G$J$/$J$j$^$9!#(B
>
>> Heap Blocks: exact=16493 lossy=79641
>
>
>paths @ "..."$B$K$7$F$b8!:w7k2L$, ＠ 5$7$/$J$i$J$1$l$P(BPGroonga$B$N(B
>$BLdBj$,9b$$$N$G:F8=$9$k$N$KI,MW$J%G!<%?!J%F!<%V%kDj5A!&%$%s%G%C(B
>$B%/%9Dj5A!&(BCOPY$B$9$k$?$a$N%G!<%?!&(BSELECT$B!K$rDs6!$7$F$b$i$($^$;(B
>$B$s$+!)(B
$B!z#3(B
$BDI2C<ALd$,$"$j$^$9!#(B
$B65$($FD:$1$J$$$G$7$g$&$+(B
$B%7!<%H!V(BSQL$BHf3S!W$N-"$N(BSQL$B$N$h$&$K!"8!:w>r7o!JItJ,0lCW!K$r(B
$B#22s;XDj$7$?(BSQL$B$r;HMQ$7$?>l9g!"(B
$B2?$+7|G0E ＠ Ey$O$"$j$^$9$G$7$g$&$+!)(B
" WHERE (order_json_info_pgroonga ->> 'applicationArrivalDate' between"
" '2018/01/01' and '2018/07/02')"
" AND (order_json_info_pgroonga operator(pgroonga.@@)"
" 'paths ==""contractCustomerName""&& string @""$B3t(B""')"
" AND (order_json_info_pgroonga operator(pgroonga.@@)"
" 'paths ==""contractCustomerName""&& string @""$B3t(B""'))"
$B!!!!!!!!(BSELECT a1.sys_no
$B$43NG'$N$[$I(B
$B$h$m$7$/$*4j$$$7$^$9!#(B
-----Original Message-----
From: groon****@lists***** [mailto:groon****@lists*****] On Behalf Of groon****@lists*****
Sent: Friday, August 17, 2018 12:00 PM
To: groon****@lists*****
Subject: groonga-dev $B$^$H$aFI$_(B, 114 $B4,(B, 5 $B9f(B
groonga-dev $B%a!<%j%s%0%j%9%H$X$NEj9F$O0J2<$N%"%I%l%9$KAw$C$F$/$@$5$$!%(B
groon****@lists*****
Web$B%V%i%&%6$r;H$C$FF~B`2q$9$k$K$O0J2<$N(BURL$B$K$I$&$>!%(B
https://lists.osdn.me/mailman/listinfo/groonga-dev
$B%a!<%k$r;H$&>l9g!$7oL>(B(Subject:)$B$^$?$OK\J8$K(B help $B$H=q$$$F0J2<$N(B
$B%"%I%l%9$KAw?.$7$F$/$@$5$$!%(B
groon****@lists*****
$B%a!<%j%s%0%j%9%H$N4IM}<T$X$NO"Mm$O!$0J2<$N%"%I%l%9$K$*4j$$$7$^$9(B.
groon****@lists*****
$BJV?.$9$k>l9g!$7oL>$r=q$-D>$7$FFbMF$,$o$+$k$h$&$K$7$F$/$@$5$$!%(B
$B$=$N$^$^$@$H!$0J2<$N$h$&$K$J$C$F$7$^$$$^$9!%(B "Re: groonga-dev
$B$^$H$aFI$_(B, XX $B4,(B XX $B9f(B"
$BK\F|$NOCBj(B:
1. [groonga-dev,04658] Re:
where$B$GF1$8>r7o$r(B2$BEY;XDj$7$J$$$H ＠ 5$7$$7k2L$,JV$i$J$$7o$K$D$$$F(B
(Kouhei Sutou)
----------------------------------------------------------------------
Message: 1
Date: Thu, 16 Aug 2018 14:28:10 +0900 (JST)
From: Kouhei Sutou <kou****@clear*****>
Subject: [groonga-dev,04658] Re:
where$B$GF1$8>r7o$r(B2$BEY;XDj$7$J$$$H ＠ 5$7$$7k2L$,JV$i$J$$7o$K$D$$$F(B
To: groon****@lists*****
Message-ID: <20180****@clear*****>
Content-Type: Text/Plain; charset=iso-2022-jp
$B?\F#$G$9!#(B
In <907B2****@WMBOX*****>
"[groonga-dev,04657] where$B$GF1$8>r7o$r(B2$BEY;XDj$7$J$$$H ＠ 5$7$$7k2L$,JV$i$J$$7o$K$D$$$F(B" on Thu, 16 Aug 2018 05:02:46 +0000,
$BF|8~(B $B=<(B <hinat****@nttco*****> wrote:
> $B!Z<ALd;v9`![(B
> $B!&(BML$B$K$4;22C$N3'MM$G$O!"2?$+$3$l$K4X$9$k>pJs$rGD0.$5$l$F$$$^$9$G$7$g$&$+!#(B
> $B!&$b$7%P%0Ey$,860x$G(BFIX$B$5$l$F$$$k$H$7$?$i$=$l$O$I$N%P!<%8%g%s$G$7$g$&$+!#(B
$B$^$:!"(Bpaths == "..."$B$r(Bpaths @ "..."$B$K$7$F$_$F$/$@$5$$!#(B
$B$3$l$G8!:w7k2L$, ＠ 5$7$/$J$k$3$H$r4|BT$7$F$$$^$9!#(B
$B!JB.EY$O$=$s$J$KJQ$o$i$J$$$+CY$/$J$k$H;W$$$^$9!#!K(B
$B8!:w7k2L$, ＠ 5$7$/$J$C$?$i!"(Bwork_mem$B$rA}$d$7$F$_$F$/$@$5$$!#(B
$B$3$l$G8!:wB.EY$b2~A1$9$k$H;W$$$^$9!#(B
$B>r7o$,(B1$B$D$N%1!<%9$G$O<!$N$h$&$K(Blossy$B$,$G$F$$$^$9$,!"$3$l$O%R%C(B
$B%H$7$?%l%3!<%I$rI=8=$9$k==J,$JBg$-$5$N%S%C%H%^%C%W$rMQ0U$G$-(B
$B$J$$$H$-$K$G$^$9!#$3$l$,$G$k$H%7!<%1%s%7%c%k%9%-%c%s$b$7$J$/(B
$B$F$O$J$/$J$jCY$/$J$k$s$G$9!#(Bwork_mem$B$r==J,$J%5%$%:$K$9$k$H(B
lossy$B$,$G$J$/$J$j$^$9!#(B
> Heap Blocks: exact=16493 lossy=79641
paths @ "..."$B$K$7$F$b8!:w7k2L$, ＠ 5$7$/$J$i$J$1$l$P(BPGroonga$B$N(B
$BLdBj$,9b$$$N$G:F8=$9$k$N$KI,MW$J%G!<%?!J%F!<%V%kDj5A!&%$%s%G%C(B
$B%/%9Dj5A!&(BCOPY$B$9$k$?$a$N%G!<%?!&(BSELECT$B!K$rDs6!$7$F$b$i$($^$;(B
$B$s$+!)(B
--
$B?\F#(B $B8yJ?(B <kou****@clear*****>
$B3t<02q<R%/%j%"%3!<%I(B <http://www.clear-code.com/>
Groonga$B%Y!<%9$NA4J88!:w%7%9%F%`$rAm9g%5%]!<%H!'(B
http://groonga.org/ja/support/
$B%G!<%?=hM}%D!<%k$N3+H/!'(B
http://www.clear-code.com/blog/2018/7/11.html
------------------------------
_______________________________________________
groonga-dev mailing list
groon****@lists*****
https://lists.osdn.me/mailman/listinfo/groonga-dev
$B0J>e(B: groonga-dev $B$^$H$aFI$_(B, 114 $B4,(B, 5 $B9f(B
******************************************