Kouhei Sutou
null+****@clear*****
Thu Nov 17 00:59:22 JST 2016
Kouhei Sutou 2016-11-17 00:59:22 +0900 (Thu, 17 Nov 2016) New Revision: 147b93f556e85d10f3f833159b95ee65ec49274b https://github.com/pgroonga/pgroonga.github.io/commit/147b93f556e85d10f3f833159b95ee65ec49274b Message: Add graph for full text search benchmark Added files: data/pgroonga-textsearch-pg-trgm/search.gnuplot data/pgroonga-textsearch-pg-trgm/search.tsv images/pgroonga-textsearch-pg-trgm/search-only-postgresql-or-mysql.svg images/pgroonga-textsearch-pg-trgm/search-without-groonga.svg images/pgroonga-textsearch-pg-trgm/search-without-pg-trgm.svg images/pgroonga-textsearch-pg-trgm/search.svg Modified files: Rakefile _config.yml reference/pgroonga-versus-textsearch-and-pg-trgm.md Modified: Rakefile (+24 -1) =================================================================== --- Rakefile 2016-11-16 19:07:00 +0900 (76309f8) +++ Rakefile 2016-11-17 00:59:22 +0900 (f6f70be) @@ -12,4 +12,27 @@ Jekyll::Task::I18n.define do |task| end end -task :default => "jekyll:i18n:translate" +plot = Pathname.new("data/pgroonga-textsearch-pg-trgm/search.gnuplot") +svgs = [] +plot.open do |plot_file| + plot_file.each_line do |line| + case line.chomp + when /\Aset output "(.*?)"\z/ + svgs << "images/pgroonga-textsearch-pg-trgm/#{$1}" + end + end +end + +key_svg = svgs.first +file key_svg => plot.to_s do + cd(plot.dirname) do + sh("gnuplot", plot.basename.to_s) + end + svgs.each do |svg| + mkdir_p(File.dirname(svg)) + mv("#{plot.dirname}/#{File.basename(svg)}", + svg) + end +end + +task :default => ["jekyll:i18n:translate", key_svg] Modified: _config.yml (+5 -1) =================================================================== --- _config.yml 2016-11-16 19:07:00 +0900 (d318b38) +++ _config.yml 2016-11-17 00:59:22 +0900 (74aee17) @@ -11,7 +11,11 @@ postgresql_doc_base_url: windows_postgresql_versions: - 9.5.5-1 - 9.6.1-1 -exclude: ["Rakefile", "Gemfile", "Gemfile.lock"] +exclude: + - "Rakefile" + - "Gemfile" + - "Gemfile.lock" + - "data" description: en: Make PostgreSQL fast full text search platform for all languages! ja: PostgreSQLで高速日本語全文検索! Added: data/pgroonga-textsearch-pg-trgm/search.gnuplot (+78 -0) 100644 =================================================================== --- /dev/null +++ data/pgroonga-textsearch-pg-trgm/search.gnuplot 2016-11-17 00:59:22 +0900 (b306bf9) @@ -0,0 +1,78 @@ +set terminal pdfcairo enhanced color transparent rounded +set terminal svg + +set key outside center top horizontal reverse Left samplen 2 +unset border +set xtics scale 0 +set ytics scale 0 +set grid ytics linewidth 1 linetype -1 + +set style line 1 lt 1 lc rgbcolor "#3465a4" lw 2.5 pt 7 ps 1 +set style line 2 lt 1 lc rgbcolor "#edd400" lw 2.5 pt 7 ps 1 +set style line 3 lt 1 lc rgbcolor "#888a85" lw 2.5 pt 5 ps 1 +set style line 4 lt 1 lc rgbcolor "#f57900" lw 2.5 pt 5 ps 1 +set style line 5 lt 1 lc rgbcolor "#ad7fa8" lw 2.5 pt 9 ps 1 +set style line 6 lt 1 lc rgbcolor "#4e9a06" lw 2.5 pt 9 ps 1 +set style line 7 lt 1 lc rgbcolor "#ef2929" lw 2.5 pt 1 ps 1 +set style line 8 lt 1 lc rgbcolor "#5c3566" lw 2.5 pt 1 ps 1 +set style line 9 lt 1 lc rgbcolor "#c17d11" lw 2.5 pt 3 ps 1 +set style line 10 lt 1 lc rgbcolor "#dce775" lw 2.5 pt 3 ps 1 + +set xlabel "\n\nQuery" +set ylabel "Elapsed time (ms)" + +set style data histogram +set style histogram cluster gap 1 +set style fill solid border -1 +set boxwidth 0.9 + +set output "search.svg" +plot "search.tsv" using 2:xtic(1) \ + title columnheader \ + linestyle 5, \ + "search.tsv" using 3:xtic(1) \ + title columnheader \ + linestyle 2, \ + "search.tsv" using 4:xtic(1) \ + title columnheader \ + linestyle 1, \ + "search.tsv" using 5:xtic(1) \ + title columnheader \ + linestyle 6 + +set output "search-without-groonga.svg" +plot "search.tsv" using 2:xtic(1) \ + title columnheader \ + linestyle 5, \ + "search.tsv" using 4:xtic(1) \ + title columnheader \ + linestyle 1, \ + "search.tsv" using 5:xtic(1) \ + title columnheader \ + linestyle 6 + +set output "search-without-pg-trgm.svg" +plot "search.tsv" using 2:xtic(1) \ + title columnheader \ + linestyle 5, \ + "search.tsv" using 3:xtic(1) \ + title columnheader \ + linestyle 2, \ + "search.tsv" using 4:xtic(1) \ + title columnheader \ + linestyle 1 + +set output "search-only-postgresql-or-mysql.svg" +set xrange [1.5:2.5] +plot "search.tsv" using 2:xtic(1) \ + title columnheader \ + linestyle 5, \ + "search.tsv" using 3:xtic(1) \ + title columnheader \ + linestyle 2, \ + "search.tsv" using 4:xtic(1) \ + title columnheader \ + linestyle 1, \ + "search.tsv" using 5:xtic(1) \ + title columnheader \ + linestyle 6 Added: data/pgroonga-textsearch-pg-trgm/search.tsv (+5 -0) 100644 =================================================================== --- /dev/null +++ data/pgroonga-textsearch-pg-trgm/search.tsv 2016-11-17 00:59:22 +0900 (c0fe6e7) @@ -0,0 +1,5 @@ +Query PGroonga Groonga textsearch pg\\_trgm +animation 173 6 1000 44000 +database 698 19 602 33000 +"PostgreSQL\nOR\nMySQL" 6 3 3 241 +America 1300 45 1200 92000 Added: images/pgroonga-textsearch-pg-trgm/search-only-postgresql-or-mysql.svg (+219 -0) 100644 =================================================================== --- /dev/null +++ images/pgroonga-textsearch-pg-trgm/search-only-postgresql-or-mysql.svg 2016-11-17 00:59:22 +0900 (db76290) @@ -0,0 +1,219 @@ +<?xml version="1.0" encoding="utf-8" standalone="no"?> +<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" + "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"> +<svg + width="600" height="480" + viewBox="0 0 600 480" + xmlns="http://www.w3.org/2000/svg" + xmlns:xlink="http://www.w3.org/1999/xlink" +> + +<title>Gnuplot</title> +<desc>Produced by GNUPLOT 5.0 patchlevel 5 </desc> + +<g id="gnuplot_canvas"> + +<rect x="0" y="0" width="600" height="480" fill="none"/> +<defs> + + <circle id='gpDot' r='0.5' stroke-width='0.5'/> + <path id='gpPt0' stroke-width='0.222' stroke='currentColor' d='M-1,0 h2 M0,-1 v2'/> + <path id='gpPt1' stroke-width='0.222' stroke='currentColor' d='M-1,-1 L1,1 M1,-1 L-1,1'/> + <path id='gpPt2' stroke-width='0.222' stroke='currentColor' d='M-1,0 L1,0 M0,-1 L0,1 M-1,-1 L1,1 M-1,1 L1,-1'/> + <rect id='gpPt3' stroke-width='0.222' stroke='currentColor' x='-1' y='-1' width='2' height='2'/> + <rect id='gpPt4' stroke-width='0.222' stroke='currentColor' fill='currentColor' x='-1' y='-1' width='2' height='2'/> + <circle id='gpPt5' stroke-width='0.222' stroke='currentColor' cx='0' cy='0' r='1'/> + <use xlink:href='#gpPt5' id='gpPt6' fill='currentColor' stroke='none'/> + <path id='gpPt7' stroke-width='0.222' stroke='currentColor' d='M0,-1.33 L-1.33,0.67 L1.33,0.67 z'/> + <use xlink:href='#gpPt7' id='gpPt8' fill='currentColor' stroke='none'/> + <use xlink:href='#gpPt7' id='gpPt9' stroke='currentColor' transform='rotate(180)'/> + <use xlink:href='#gpPt9' id='gpPt10' fill='currentColor' stroke='none'/> + <use xlink:href='#gpPt3' id='gpPt11' stroke='currentColor' transform='rotate(45)'/> + <use xlink:href='#gpPt11' id='gpPt12' fill='currentColor' stroke='none'/> + <path id='gpPt13' stroke-width='0.222' stroke='currentColor' d='M0,1.330 L1.265,0.411 L0.782,-1.067 L-0.782,-1.076 L-1.265,0.411 z'/> + <use xlink:href='#gpPt13' id='gpPt14' fill='currentColor' stroke='none'/> + <filter id='textbox' filterUnits='objectBoundingBox' x='0' y='0' height='1' width='1'> + <feFlood flood-color='white' flood-opacity='1' result='bgnd'/> + <feComposite in='SourceGraphic' in2='bgnd' operator='atop'/> + </filter> + <filter id='greybox' filterUnits='objectBoundingBox' x='0' y='0' height='1' width='1'> + <feFlood flood-color='lightgrey' flood-opacity='1' result='grey'/> + <feComposite in='SourceGraphic' in2='grey' operator='atop'/> + </filter> +</defs> +<g fill="none" color="white" stroke="black" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M71.9,386.4 L575.0,386.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M71.9,386.4 M575.0,386.4 '/> <g transform="translate(63.6,390.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 0</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M71.9,316.1 L575.0,316.1 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M71.9,316.1 M575.0,316.1 '/> <g transform="translate(63.6,320.0)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 50</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M71.9,245.7 L575.0,245.7 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M71.9,245.7 M575.0,245.7 '/> <g transform="translate(63.6,249.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 100</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M71.9,175.4 L575.0,175.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M71.9,175.4 M575.0,175.4 '/> <g transform="translate(63.6,179.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 150</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M71.9,105.0 L575.0,105.0 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M71.9,105.0 M575.0,105.0 '/> <g transform="translate(63.6,108.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 200</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M71.9,34.7 L575.0,34.7 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M71.9,34.7 M575.0,34.7 '/> <g transform="translate(63.6,38.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 250</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M323.5,386.4 M323.5,34.7 '/> <g transform="translate(323.5,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >PostgreSQL</tspan></text> + </g> + <g transform="translate(323.5,426.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >OR</tspan></text> + </g> + <g transform="translate(323.5,444.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >MySQL</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(17.0,210.6) rotate(270)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Elapsed time (ms)</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(323.4,435.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text></text> + </g> + <g transform="translate(323.4,453.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text></text> + </g> + <g transform="translate(323.4,471.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Query</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + <g id="gnuplot_plot_1" ><title>PGroonga</title> +<g fill="none" color="white" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(115.2,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >PGroonga</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '81.3,22.5 106.9,22.5 106.9,13.5 81.3,13.5 '/> + </g> + <path stroke='black' d='M81.3,22.5 L106.9,22.5 L106.9,13.5 L81.3,13.5 L81.3,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '127.2,386.4 217.9,386.4 217.9,377.9 127.2,377.9 '/> + </g> + <path stroke='black' d='M127.2,386.4 L127.2,378.0 L217.8,378.0 L217.8,386.4 L127.2,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_2" ><title>Groonga</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(240.4,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >Groonga</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '206.5,22.5 232.1,22.5 232.1,13.5 206.5,13.5 '/> + </g> + <path stroke='black' d='M206.5,22.5 L232.1,22.5 L232.1,13.5 L206.5,13.5 L206.5,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '227.9,386.4 318.5,386.4 318.5,382.1 227.9,382.1 '/> + </g> + <path stroke='black' d='M227.9,386.4 L227.9,382.2 L318.4,382.2 L318.4,386.4 L227.9,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_3" ><title>textsearch</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(365.6,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >textsearch</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '331.7,22.5 357.3,22.5 357.3,13.5 331.7,13.5 '/> + </g> + <path stroke='black' d='M331.7,22.5 L357.3,22.5 L357.3,13.5 L331.7,13.5 L331.7,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '328.5,386.4 419.1,386.4 419.1,382.1 328.5,382.1 '/> + </g> + <path stroke='black' d='M328.5,386.4 L328.5,382.2 L419.0,382.2 L419.0,386.4 L328.5,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_4" ><title>pg_trgm</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(490.8,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >pg_trgm</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '456.9,22.5 482.5,22.5 482.5,13.5 456.9,13.5 '/> + </g> + <path stroke='black' d='M456.9,22.5 L482.5,22.5 L482.5,13.5 L456.9,13.5 L456.9,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '429.1,386.4 519.8,386.4 519.8,47.3 429.1,47.3 '/> + </g> + <path stroke='black' d='M429.1,386.4 L429.1,47.4 L519.7,47.4 L519.7,386.4 L429.1,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> +<g fill="none" color="white" stroke="rgb( 78, 154, 6)" stroke-width="2.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="black" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +</g> +</svg> + Added: images/pgroonga-textsearch-pg-trgm/search-without-groonga.svg (+305 -0) 100644 =================================================================== --- /dev/null +++ images/pgroonga-textsearch-pg-trgm/search-without-groonga.svg 2016-11-17 00:59:22 +0900 (be19bb1) @@ -0,0 +1,305 @@ +<?xml version="1.0" encoding="utf-8" standalone="no"?> +<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" + "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"> +<svg + width="600" height="480" + viewBox="0 0 600 480" + xmlns="http://www.w3.org/2000/svg" + xmlns:xlink="http://www.w3.org/1999/xlink" +> + +<title>Gnuplot</title> +<desc>Produced by GNUPLOT 5.0 patchlevel 5 </desc> + +<g id="gnuplot_canvas"> + +<rect x="0" y="0" width="600" height="480" fill="none"/> +<defs> + + <circle id='gpDot' r='0.5' stroke-width='0.5'/> + <path id='gpPt0' stroke-width='0.222' stroke='currentColor' d='M-1,0 h2 M0,-1 v2'/> + <path id='gpPt1' stroke-width='0.222' stroke='currentColor' d='M-1,-1 L1,1 M1,-1 L-1,1'/> + <path id='gpPt2' stroke-width='0.222' stroke='currentColor' d='M-1,0 L1,0 M0,-1 L0,1 M-1,-1 L1,1 M-1,1 L1,-1'/> + <rect id='gpPt3' stroke-width='0.222' stroke='currentColor' x='-1' y='-1' width='2' height='2'/> + <rect id='gpPt4' stroke-width='0.222' stroke='currentColor' fill='currentColor' x='-1' y='-1' width='2' height='2'/> + <circle id='gpPt5' stroke-width='0.222' stroke='currentColor' cx='0' cy='0' r='1'/> + <use xlink:href='#gpPt5' id='gpPt6' fill='currentColor' stroke='none'/> + <path id='gpPt7' stroke-width='0.222' stroke='currentColor' d='M0,-1.33 L-1.33,0.67 L1.33,0.67 z'/> + <use xlink:href='#gpPt7' id='gpPt8' fill='currentColor' stroke='none'/> + <use xlink:href='#gpPt7' id='gpPt9' stroke='currentColor' transform='rotate(180)'/> + <use xlink:href='#gpPt9' id='gpPt10' fill='currentColor' stroke='none'/> + <use xlink:href='#gpPt3' id='gpPt11' stroke='currentColor' transform='rotate(45)'/> + <use xlink:href='#gpPt11' id='gpPt12' fill='currentColor' stroke='none'/> + <path id='gpPt13' stroke-width='0.222' stroke='currentColor' d='M0,1.330 L1.265,0.411 L0.782,-1.067 L-0.782,-1.076 L-1.265,0.411 z'/> + <use xlink:href='#gpPt13' id='gpPt14' fill='currentColor' stroke='none'/> + <filter id='textbox' filterUnits='objectBoundingBox' x='0' y='0' height='1' width='1'> + <feFlood flood-color='white' flood-opacity='1' result='bgnd'/> + <feComposite in='SourceGraphic' in2='bgnd' operator='atop'/> + </filter> + <filter id='greybox' filterUnits='objectBoundingBox' x='0' y='0' height='1' width='1'> + <feFlood flood-color='lightgrey' flood-opacity='1' result='grey'/> + <feComposite in='SourceGraphic' in2='grey' operator='atop'/> + </filter> +</defs> +<g fill="none" color="white" stroke="black" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,386.4 L575.0,386.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,386.4 M575.0,386.4 '/> <g transform="translate(88.5,390.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 0</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,351.2 L575.0,351.2 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,351.2 M575.0,351.2 '/> <g transform="translate(88.5,355.1)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 10000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,316.1 L575.0,316.1 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,316.1 M575.0,316.1 '/> <g transform="translate(88.5,320.0)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 20000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,280.9 L575.0,280.9 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,280.9 M575.0,280.9 '/> <g transform="translate(88.5,284.8)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 30000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,245.7 L575.0,245.7 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,245.7 M575.0,245.7 '/> <g transform="translate(88.5,249.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 40000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,210.5 L575.0,210.5 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,210.5 M575.0,210.5 '/> <g transform="translate(88.5,214.4)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 50000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,175.4 L575.0,175.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,175.4 M575.0,175.4 '/> <g transform="translate(88.5,179.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 60000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,140.2 L575.0,140.2 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,140.2 M575.0,140.2 '/> <g transform="translate(88.5,144.1)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 70000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,105.0 L575.0,105.0 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,105.0 M575.0,105.0 '/> <g transform="translate(88.5,108.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 80000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,69.9 L575.0,69.9 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,69.9 M575.0,69.9 '/> <g transform="translate(88.5,73.8)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 90000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,34.7 L575.0,34.7 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,34.7 M575.0,34.7 '/> <g transform="translate(88.5,38.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 100000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M192.4,386.4 M192.4,34.7 '/> <g transform="translate(192.4,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >animation</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M288.1,386.4 M288.1,34.7 '/> <g transform="translate(288.1,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >database</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M383.7,386.4 M383.7,34.7 '/> <g transform="translate(383.7,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >PostgreSQL</tspan></text> + </g> + <g transform="translate(383.7,426.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >OR</tspan></text> + </g> + <g transform="translate(383.7,444.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >MySQL</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M479.4,386.4 M479.4,34.7 '/> <g transform="translate(479.4,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >America</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(17.0,210.6) rotate(270)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Elapsed time (ms)</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(335.9,435.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text></text> + </g> + <g transform="translate(335.9,453.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text></text> + </g> + <g transform="translate(335.9,471.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Query</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + <g id="gnuplot_plot_1" ><title>PGroonga</title> +<g fill="none" color="white" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(190.3,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >PGroonga</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '156.4,22.5 182.0,22.5 182.0,13.5 156.4,13.5 '/> + </g> + <path stroke='black' d='M156.4,22.5 L182.0,22.5 L182.0,13.5 L156.4,13.5 L156.4,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '157.8,386.4 179.4,386.4 179.4,385.7 157.8,385.7 '/> + </g> + <path stroke='black' d='M157.8,386.4 L157.8,385.8 L179.3,385.8 L179.3,386.4 L157.8,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '253.4,386.4 275.0,386.4 275.0,383.8 253.4,383.8 '/> + </g> + <path stroke='black' d='M253.4,386.4 L253.4,383.9 L274.9,383.9 L274.9,386.4 L253.4,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '349.1,386.4 370.7,386.4 370.7,386.3 349.1,386.3 '/> + </g> + <path stroke='black' d='M349.1,386.4 L370.6,386.4 L349.1,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '444.7,386.4 466.3,386.4 466.3,381.7 444.7,381.7 '/> + </g> + <path stroke='black' d='M444.7,386.4 L444.7,381.8 L466.2,381.8 L466.2,386.4 L444.7,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_2" ><title>textsearch</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(315.5,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >textsearch</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '281.6,22.5 307.2,22.5 307.2,13.5 281.6,13.5 '/> + </g> + <path stroke='black' d='M281.6,22.5 L307.2,22.5 L307.2,13.5 L281.6,13.5 L281.6,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '181.7,386.4 203.3,386.4 203.3,382.8 181.7,382.8 '/> + </g> + <path stroke='black' d='M181.7,386.4 L181.7,382.9 L203.2,382.9 L203.2,386.4 L181.7,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '277.3,386.4 298.9,386.4 298.9,384.2 277.3,384.2 '/> + </g> + <path stroke='black' d='M277.3,386.4 L277.3,384.3 L298.8,384.3 L298.8,386.4 L277.3,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '373.0,386.4 394.6,386.4 394.6,386.3 373.0,386.3 '/> + </g> + <path stroke='black' d='M373.0,386.4 L394.5,386.4 L373.0,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '468.6,386.4 490.2,386.4 490.2,382.1 468.6,382.1 '/> + </g> + <path stroke='black' d='M468.6,386.4 L468.6,382.2 L490.1,382.2 L490.1,386.4 L468.6,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_3" ><title>pg_trgm</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(440.7,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >pg_trgm</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '406.8,22.5 432.4,22.5 432.4,13.5 406.8,13.5 '/> + </g> + <path stroke='black' d='M406.8,22.5 L432.4,22.5 L432.4,13.5 L406.8,13.5 L406.8,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '205.6,386.4 227.2,386.4 227.2,231.6 205.6,231.6 '/> + </g> + <path stroke='black' d='M205.6,386.4 L205.6,231.7 L227.1,231.7 L227.1,386.4 L205.6,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '301.2,386.4 322.8,386.4 322.8,270.2 301.2,270.2 '/> + </g> + <path stroke='black' d='M301.2,386.4 L301.2,270.3 L322.7,270.3 L322.7,386.4 L301.2,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '396.9,386.4 418.5,386.4 418.5,385.5 396.9,385.5 '/> + </g> + <path stroke='black' d='M396.9,386.4 L396.9,385.6 L418.4,385.6 L418.4,386.4 L396.9,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '492.5,386.4 514.1,386.4 514.1,62.7 492.5,62.7 '/> + </g> + <path stroke='black' d='M492.5,386.4 L492.5,62.8 L514.0,62.8 L514.0,386.4 L492.5,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> +<g fill="none" color="white" stroke="rgb( 78, 154, 6)" stroke-width="2.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="black" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +</g> +</svg> + Added: images/pgroonga-textsearch-pg-trgm/search-without-pg-trgm.svg (+278 -0) 100644 =================================================================== --- /dev/null +++ images/pgroonga-textsearch-pg-trgm/search-without-pg-trgm.svg 2016-11-17 00:59:22 +0900 (4db636e) @@ -0,0 +1,278 @@ +<?xml version="1.0" encoding="utf-8" standalone="no"?> +<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" + "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"> +<svg + width="600" height="480" + viewBox="0 0 600 480" + xmlns="http://www.w3.org/2000/svg" + xmlns:xlink="http://www.w3.org/1999/xlink" +> + +<title>Gnuplot</title> +<desc>Produced by GNUPLOT 5.0 patchlevel 5 </desc> + +<g id="gnuplot_canvas"> + +<rect x="0" y="0" width="600" height="480" fill="none"/> +<defs> + + <circle id='gpDot' r='0.5' stroke-width='0.5'/> + <path id='gpPt0' stroke-width='0.222' stroke='currentColor' d='M-1,0 h2 M0,-1 v2'/> + <path id='gpPt1' stroke-width='0.222' stroke='currentColor' d='M-1,-1 L1,1 M1,-1 L-1,1'/> + <path id='gpPt2' stroke-width='0.222' stroke='currentColor' d='M-1,0 L1,0 M0,-1 L0,1 M-1,-1 L1,1 M-1,1 L1,-1'/> + <rect id='gpPt3' stroke-width='0.222' stroke='currentColor' x='-1' y='-1' width='2' height='2'/> + <rect id='gpPt4' stroke-width='0.222' stroke='currentColor' fill='currentColor' x='-1' y='-1' width='2' height='2'/> + <circle id='gpPt5' stroke-width='0.222' stroke='currentColor' cx='0' cy='0' r='1'/> + <use xlink:href='#gpPt5' id='gpPt6' fill='currentColor' stroke='none'/> + <path id='gpPt7' stroke-width='0.222' stroke='currentColor' d='M0,-1.33 L-1.33,0.67 L1.33,0.67 z'/> + <use xlink:href='#gpPt7' id='gpPt8' fill='currentColor' stroke='none'/> + <use xlink:href='#gpPt7' id='gpPt9' stroke='currentColor' transform='rotate(180)'/> + <use xlink:href='#gpPt9' id='gpPt10' fill='currentColor' stroke='none'/> + <use xlink:href='#gpPt3' id='gpPt11' stroke='currentColor' transform='rotate(45)'/> + <use xlink:href='#gpPt11' id='gpPt12' fill='currentColor' stroke='none'/> + <path id='gpPt13' stroke-width='0.222' stroke='currentColor' d='M0,1.330 L1.265,0.411 L0.782,-1.067 L-0.782,-1.076 L-1.265,0.411 z'/> + <use xlink:href='#gpPt13' id='gpPt14' fill='currentColor' stroke='none'/> + <filter id='textbox' filterUnits='objectBoundingBox' x='0' y='0' height='1' width='1'> + <feFlood flood-color='white' flood-opacity='1' result='bgnd'/> + <feComposite in='SourceGraphic' in2='bgnd' operator='atop'/> + </filter> + <filter id='greybox' filterUnits='objectBoundingBox' x='0' y='0' height='1' width='1'> + <feFlood flood-color='lightgrey' flood-opacity='1' result='grey'/> + <feComposite in='SourceGraphic' in2='grey' operator='atop'/> + </filter> +</defs> +<g fill="none" color="white" stroke="black" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M80.2,386.4 L575.0,386.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M80.2,386.4 M575.0,386.4 '/> <g transform="translate(71.9,390.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 0</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M80.2,336.2 L575.0,336.2 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M80.2,336.2 M575.0,336.2 '/> <g transform="translate(71.9,340.1)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 200</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M80.2,285.9 L575.0,285.9 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M80.2,285.9 M575.0,285.9 '/> <g transform="translate(71.9,289.8)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 400</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M80.2,235.7 L575.0,235.7 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M80.2,235.7 M575.0,235.7 '/> <g transform="translate(71.9,239.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 600</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M80.2,185.4 L575.0,185.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M80.2,185.4 M575.0,185.4 '/> <g transform="translate(71.9,189.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 800</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M80.2,135.2 L575.0,135.2 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M80.2,135.2 M575.0,135.2 '/> <g transform="translate(71.9,139.1)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 1000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M80.2,84.9 L575.0,84.9 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M80.2,84.9 M575.0,84.9 '/> <g transform="translate(71.9,88.8)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 1200</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M80.2,34.7 L575.0,34.7 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M80.2,34.7 M575.0,34.7 '/> <g transform="translate(71.9,38.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 1400</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M179.2,386.4 M179.2,34.7 '/> <g transform="translate(179.2,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >animation</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M278.1,386.4 M278.1,34.7 '/> <g transform="translate(278.1,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >database</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M377.1,386.4 M377.1,34.7 '/> <g transform="translate(377.1,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >PostgreSQL</tspan></text> + </g> + <g transform="translate(377.1,426.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >OR</tspan></text> + </g> + <g transform="translate(377.1,444.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >MySQL</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M476.0,386.4 M476.0,34.7 '/> <g transform="translate(476.0,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >America</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(17.0,210.6) rotate(270)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Elapsed time (ms)</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(327.6,435.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text></text> + </g> + <g transform="translate(327.6,453.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text></text> + </g> + <g transform="translate(327.6,471.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Query</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + <g id="gnuplot_plot_1" ><title>PGroonga</title> +<g fill="none" color="white" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(182.0,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >PGroonga</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '148.1,22.5 173.7,22.5 173.7,13.5 148.1,13.5 '/> + </g> + <path stroke='black' d='M148.1,22.5 L173.7,22.5 L173.7,13.5 L148.1,13.5 L148.1,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '143.3,386.4 165.7,386.4 165.7,342.8 143.3,342.8 '/> + </g> + <path stroke='black' d='M143.3,386.4 L143.3,342.9 L165.6,342.9 L165.6,386.4 L143.3,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '242.2,386.4 264.6,386.4 264.6,211.0 242.2,211.0 '/> + </g> + <path stroke='black' d='M242.2,386.4 L242.2,211.1 L264.5,211.1 L264.5,386.4 L242.2,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '341.2,386.4 363.6,386.4 363.6,384.8 341.2,384.8 '/> + </g> + <path stroke='black' d='M341.2,386.4 L341.2,384.9 L363.5,384.9 L363.5,386.4 L341.2,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '440.2,386.4 462.5,386.4 462.5,59.7 440.2,59.7 '/> + </g> + <path stroke='black' d='M440.2,386.4 L440.2,59.8 L462.4,59.8 L462.4,386.4 L440.2,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_2" ><title>Groonga</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(307.2,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >Groonga</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '273.3,22.5 298.9,22.5 298.9,13.5 273.3,13.5 '/> + </g> + <path stroke='black' d='M273.3,22.5 L298.9,22.5 L298.9,13.5 L273.3,13.5 L273.3,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '168.0,386.4 190.4,386.4 190.4,384.8 168.0,384.8 '/> + </g> + <path stroke='black' d='M168.0,386.4 L168.0,384.9 L190.3,384.9 L190.3,386.4 L168.0,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '267.0,386.4 289.4,386.4 289.4,381.5 267.0,381.5 '/> + </g> + <path stroke='black' d='M267.0,386.4 L267.0,381.6 L289.3,381.6 L289.3,386.4 L267.0,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '365.9,386.4 388.3,386.4 388.3,385.5 365.9,385.5 '/> + </g> + <path stroke='black' d='M365.9,386.4 L365.9,385.6 L388.2,385.6 L388.2,386.4 L365.9,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '464.9,386.4 487.3,386.4 487.3,375.0 464.9,375.0 '/> + </g> + <path stroke='black' d='M464.9,386.4 L464.9,375.1 L487.2,375.1 L487.2,386.4 L464.9,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_3" ><title>textsearch</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(432.4,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >textsearch</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '398.5,22.5 424.1,22.5 424.1,13.5 398.5,13.5 '/> + </g> + <path stroke='black' d='M398.5,22.5 L424.1,22.5 L424.1,13.5 L398.5,13.5 L398.5,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '192.8,386.4 215.1,386.4 215.1,135.1 192.8,135.1 '/> + </g> + <path stroke='black' d='M192.8,386.4 L192.8,135.2 L215.0,135.2 L215.0,386.4 L192.8,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '291.7,386.4 314.1,386.4 314.1,235.1 291.7,235.1 '/> + </g> + <path stroke='black' d='M291.7,386.4 L291.7,235.2 L314.0,235.2 L314.0,386.4 L291.7,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '390.7,386.4 413.1,386.4 413.1,385.5 390.7,385.5 '/> + </g> + <path stroke='black' d='M390.7,386.4 L390.7,385.6 L413.0,385.6 L413.0,386.4 L390.7,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '489.6,386.4 512.0,386.4 512.0,84.8 489.6,84.8 '/> + </g> + <path stroke='black' d='M489.6,386.4 L489.6,84.9 L511.9,84.9 L511.9,386.4 L489.6,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> +<g fill="none" color="white" stroke="rgb( 52, 101, 164)" stroke-width="2.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="black" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +</g> +</svg> + Added: images/pgroonga-textsearch-pg-trgm/search.svg (+339 -0) 100644 =================================================================== --- /dev/null +++ images/pgroonga-textsearch-pg-trgm/search.svg 2016-11-17 00:59:22 +0900 (9576ce9) @@ -0,0 +1,339 @@ +<?xml version="1.0" encoding="utf-8" standalone="no"?> +<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" + "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"> +<svg + width="600" height="480" + viewBox="0 0 600 480" + xmlns="http://www.w3.org/2000/svg" + xmlns:xlink="http://www.w3.org/1999/xlink" +> + +<title>Gnuplot</title> +<desc>Produced by GNUPLOT 5.0 patchlevel 5 </desc> + +<g id="gnuplot_canvas"> + +<rect x="0" y="0" width="600" height="480" fill="none"/> +<defs> + + <circle id='gpDot' r='0.5' stroke-width='0.5'/> + <path id='gpPt0' stroke-width='0.222' stroke='currentColor' d='M-1,0 h2 M0,-1 v2'/> + <path id='gpPt1' stroke-width='0.222' stroke='currentColor' d='M-1,-1 L1,1 M1,-1 L-1,1'/> + <path id='gpPt2' stroke-width='0.222' stroke='currentColor' d='M-1,0 L1,0 M0,-1 L0,1 M-1,-1 L1,1 M-1,1 L1,-1'/> + <rect id='gpPt3' stroke-width='0.222' stroke='currentColor' x='-1' y='-1' width='2' height='2'/> + <rect id='gpPt4' stroke-width='0.222' stroke='currentColor' fill='currentColor' x='-1' y='-1' width='2' height='2'/> + <circle id='gpPt5' stroke-width='0.222' stroke='currentColor' cx='0' cy='0' r='1'/> + <use xlink:href='#gpPt5' id='gpPt6' fill='currentColor' stroke='none'/> + <path id='gpPt7' stroke-width='0.222' stroke='currentColor' d='M0,-1.33 L-1.33,0.67 L1.33,0.67 z'/> + <use xlink:href='#gpPt7' id='gpPt8' fill='currentColor' stroke='none'/> + <use xlink:href='#gpPt7' id='gpPt9' stroke='currentColor' transform='rotate(180)'/> + <use xlink:href='#gpPt9' id='gpPt10' fill='currentColor' stroke='none'/> + <use xlink:href='#gpPt3' id='gpPt11' stroke='currentColor' transform='rotate(45)'/> + <use xlink:href='#gpPt11' id='gpPt12' fill='currentColor' stroke='none'/> + <path id='gpPt13' stroke-width='0.222' stroke='currentColor' d='M0,1.330 L1.265,0.411 L0.782,-1.067 L-0.782,-1.076 L-1.265,0.411 z'/> + <use xlink:href='#gpPt13' id='gpPt14' fill='currentColor' stroke='none'/> + <filter id='textbox' filterUnits='objectBoundingBox' x='0' y='0' height='1' width='1'> + <feFlood flood-color='white' flood-opacity='1' result='bgnd'/> + <feComposite in='SourceGraphic' in2='bgnd' operator='atop'/> + </filter> + <filter id='greybox' filterUnits='objectBoundingBox' x='0' y='0' height='1' width='1'> + <feFlood flood-color='lightgrey' flood-opacity='1' result='grey'/> + <feComposite in='SourceGraphic' in2='grey' operator='atop'/> + </filter> +</defs> +<g fill="none" color="white" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,386.4 L575.0,386.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,386.4 M575.0,386.4 '/> <g transform="translate(88.5,390.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 0</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,351.2 L575.0,351.2 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,351.2 M575.0,351.2 '/> <g transform="translate(88.5,355.1)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 10000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,316.1 L575.0,316.1 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,316.1 M575.0,316.1 '/> <g transform="translate(88.5,320.0)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 20000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,280.9 L575.0,280.9 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,280.9 M575.0,280.9 '/> <g transform="translate(88.5,284.8)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 30000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,245.7 L575.0,245.7 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,245.7 M575.0,245.7 '/> <g transform="translate(88.5,249.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 40000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,210.5 L575.0,210.5 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,210.5 M575.0,210.5 '/> <g transform="translate(88.5,214.4)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 50000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,175.4 L575.0,175.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,175.4 M575.0,175.4 '/> <g transform="translate(88.5,179.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 60000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,140.2 L575.0,140.2 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,140.2 M575.0,140.2 '/> <g transform="translate(88.5,144.1)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 70000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,105.0 L575.0,105.0 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,105.0 M575.0,105.0 '/> <g transform="translate(88.5,108.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 80000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,69.9 L575.0,69.9 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,69.9 M575.0,69.9 '/> <g transform="translate(88.5,73.8)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 90000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' class="gridline" d='M96.8,34.7 L575.0,34.7 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M96.8,34.7 M575.0,34.7 '/> <g transform="translate(88.5,38.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 100000</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M192.4,386.4 M192.4,34.7 '/> <g transform="translate(192.4,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >animation</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M288.1,386.4 M288.1,34.7 '/> <g transform="translate(288.1,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >database</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M383.7,386.4 M383.7,34.7 '/> <g transform="translate(383.7,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >PostgreSQL</tspan></text> + </g> + <g transform="translate(383.7,426.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >OR</tspan></text> + </g> + <g transform="translate(383.7,444.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >MySQL</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M479.4,386.4 M479.4,34.7 '/> <g transform="translate(479.4,408.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >America</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(17.0,210.6) rotate(270)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Elapsed time (ms)</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(335.9,435.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text></text> + </g> + <g transform="translate(335.9,453.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text></text> + </g> + <g transform="translate(335.9,471.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Query</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + <g id="gnuplot_plot_1" ><title>PGroonga</title> +<g fill="none" color="white" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(127.7,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >PGroonga</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '93.8,22.5 119.4,22.5 119.4,13.5 93.8,13.5 '/> + </g> + <path stroke='black' d='M93.8,22.5 L119.4,22.5 L119.4,13.5 L93.8,13.5 L93.8,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '155.1,386.4 172.5,386.4 172.5,385.7 155.1,385.7 '/> + </g> + <path stroke='black' d='M155.1,386.4 L155.1,385.8 L172.4,385.8 L172.4,386.4 L155.1,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '250.8,386.4 268.1,386.4 268.1,383.8 250.8,383.8 '/> + </g> + <path stroke='black' d='M250.8,386.4 L250.8,383.9 L268.0,383.9 L268.0,386.4 L250.8,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '346.4,386.4 363.7,386.4 363.7,386.3 346.4,386.3 '/> + </g> + <path stroke='black' d='M346.4,386.4 L363.6,386.4 L346.4,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(173, 127, 168)' points = '442.1,386.4 459.4,386.4 459.4,381.7 442.1,381.7 '/> + </g> + <path stroke='black' d='M442.1,386.4 L442.1,381.8 L459.3,381.8 L459.3,386.4 L442.1,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_2" ><title>Groonga</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(252.9,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >Groonga</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '219.0,22.5 244.6,22.5 244.6,13.5 219.0,13.5 '/> + </g> + <path stroke='black' d='M219.0,22.5 L244.6,22.5 L244.6,13.5 L219.0,13.5 L219.0,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '174.3,386.4 191.6,386.4 191.6,386.3 174.3,386.3 '/> + </g> + <path stroke='black' d='M174.3,386.4 L191.5,386.4 L174.3,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '269.9,386.4 287.2,386.4 287.2,386.2 269.9,386.2 '/> + </g> + <path stroke='black' d='M269.9,386.4 L269.9,386.3 L287.1,386.3 L287.1,386.4 L269.9,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '365.5,386.4 382.9,386.4 382.9,386.3 365.5,386.3 '/> + </g> + <path stroke='black' d='M365.5,386.4 L382.8,386.4 L365.5,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb(237, 212, 0)' points = '461.2,386.4 478.5,386.4 478.5,386.1 461.2,386.1 '/> + </g> + <path stroke='black' d='M461.2,386.4 L461.2,386.2 L478.4,386.2 L478.4,386.4 L461.2,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_3" ><title>textsearch</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(378.1,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >textsearch</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '344.2,22.5 369.8,22.5 369.8,13.5 344.2,13.5 '/> + </g> + <path stroke='black' d='M344.2,22.5 L369.8,22.5 L369.8,13.5 L344.2,13.5 L344.2,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '193.4,386.4 210.7,386.4 210.7,382.8 193.4,382.8 '/> + </g> + <path stroke='black' d='M193.4,386.4 L193.4,382.9 L210.6,382.9 L210.6,386.4 L193.4,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '289.0,386.4 306.4,386.4 306.4,384.2 289.0,384.2 '/> + </g> + <path stroke='black' d='M289.0,386.4 L289.0,384.3 L306.3,384.3 L306.3,386.4 L289.0,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '384.7,386.4 402.0,386.4 402.0,386.3 384.7,386.3 '/> + </g> + <path stroke='black' d='M384.7,386.4 L401.9,386.4 L384.7,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 52, 101, 164)' points = '480.3,386.4 497.6,386.4 497.6,382.1 480.3,382.1 '/> + </g> + <path stroke='black' d='M480.3,386.4 L480.3,382.2 L497.5,382.2 L497.5,386.4 L480.3,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> + <g id="gnuplot_plot_4" ><title>pg_trgm</title> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(503.3,21.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="start"> + <text><tspan font-family="Arial" >pg_trgm</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '469.4,22.5 495.0,22.5 495.0,13.5 469.4,13.5 '/> + </g> + <path stroke='black' d='M469.4,22.5 L495.0,22.5 L495.0,13.5 L469.4,13.5 L469.4,22.5 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '212.5,386.4 229.8,386.4 229.8,231.6 212.5,231.6 '/> + </g> + <path stroke='black' d='M212.5,386.4 L212.5,231.7 L229.7,231.7 L229.7,386.4 L212.5,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '308.2,386.4 325.5,386.4 325.5,270.2 308.2,270.2 '/> + </g> + <path stroke='black' d='M308.2,386.4 L308.2,270.3 L325.4,270.3 L325.4,386.4 L308.2,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '403.8,386.4 421.1,386.4 421.1,385.5 403.8,385.5 '/> + </g> + <path stroke='black' d='M403.8,386.4 L403.8,385.6 L421.0,385.6 L421.0,386.4 L403.8,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> + <g stroke='none' shape-rendering='crispEdges'> + <polygon fill = 'rgb( 78, 154, 6)' points = '499.4,386.4 516.8,386.4 516.8,62.7 499.4,62.7 '/> + </g> + <path stroke='black' d='M499.4,386.4 L499.4,62.8 L516.7,62.8 L516.7,386.4 L499.4,386.4 Z '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.50" stroke-linecap="butt" stroke-linejoin="miter"> +</g> + </g> +<g fill="none" color="white" stroke="rgb( 78, 154, 6)" stroke-width="2.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="2.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="black" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> +</g> +</g> +</svg> + Modified: reference/pgroonga-versus-textsearch-and-pg-trgm.md (+4 -4) =================================================================== --- reference/pgroonga-versus-textsearch-and-pg-trgm.md 2016-11-16 19:07:00 +0900 (bdeaef5) +++ reference/pgroonga-versus-textsearch-and-pg-trgm.md 2016-11-17 00:59:22 +0900 (abcf4c6) @@ -194,8 +194,8 @@ Module | Elapsed time | N hits | Relative time | Note ---------- | ------------ | ------------------ | ------------- | ---- PGroonga | About 173ms | About 40thousands | About 29 | Groonga | About 6ms | About 40thousands | 1 | -pg\_trgm | About 44s | About 30thousands | About 7333 | textsearch | About 1s | About 420thousands | About 167 | N hits is about 10 times than other cases. It's caused by stemming. "animation" is stemmed as "anim" and "anim" is searched. +pg\_trgm | About 44s | About 30thousands | About 7333 | Query: "database" @@ -203,8 +203,8 @@ Module | Elapsed time | N hits | Relative time ---------- | ------------ | ------------------ | ------------- PGroonga | About 698ms | About 210thousands | About 37 Groonga | About 19ms | About 210thousands | 1 -pg\_trgm | About 33s | About 130thousands | About 1736 textsearch | About 602ms | About 190thousands | About 32 +pg\_trgm | About 33s | About 130thousands | About 1736 Query: "PostgreSQL OR MySQL" @@ -213,8 +213,8 @@ Module | Elapsed time | N hits | Relative time ---------- | ------------ | ------------------ | ------------- PGroonga | About 6ms | 1636 | About 2 Groonga | About 3ms | 1636 | 1 -pg\_trgm | About 241ms | 1484 | About 80 textsearch | About 3ms | 1506 | 1 +pg\_trgm | About 241ms | 1484 | About 80 Query: "America" @@ -222,5 +222,5 @@ Module | Elapsed time | N hits | Relative time ---------- | ------------ | ------------------ | ------------- PGroonga | About 1.3s | About 470thousands | About 29 Groonga | About 45ms | About 470thousands | 1 -pg\_trgm | About 1m32s | About 1.4millions | About 2044 textsearch | About 1.2s | About 480thousands | About 26 +pg\_trgm | About 1m32s | About 1.4millions | About 2044 -------------- next part -------------- HTML����������������������������... ダウンロード