Kouhei Sutou
null+****@clear*****
Thu Nov 17 11:56:43 JST 2016
Kouhei Sutou 2016-11-17 11:56:43 +0900 (Thu, 17 Nov 2016) New Revision: 850686d734a0aca807e282c4814837287a264027 https://github.com/pgroonga/pgroonga.github.io/commit/850686d734a0aca807e282c4814837287a264027 Message: Add graph for index creation Added files: data/pgroonga-textsearch-pg-trgm/index-creation.gnuplot data/pgroonga-textsearch-pg-trgm/index-creation.tsv images/pgroonga-textsearch-pg-trgm/index-creation.svg Added: data/pgroonga-textsearch-pg-trgm/index-creation.gnuplot (+41 -0) 100644 =================================================================== --- /dev/null +++ data/pgroonga-textsearch-pg-trgm/index-creation.gnuplot 2016-11-17 11:56:43 +0900 (b314b70) @@ -0,0 +1,41 @@ +# 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 "Module" +set ylabel "Elapsed time (hour)\n(Shorter is better)" +set noxtic + +set yrange[0:] + +set style data histogram +set style histogram cluster gap 1 +set style fill solid border -1 +set boxwidth 0.9 + +set output "index-creation.svg" +plot "index-creation.tsv" using 1 \ + title columnheader \ + linestyle 5, \ + "index-creation.tsv" using 2 \ + title columnheader \ + linestyle 1, \ + "index-creation.tsv" using 3 \ + title columnheader \ + linestyle 6 Added: data/pgroonga-textsearch-pg-trgm/index-creation.tsv (+2 -0) 100644 =================================================================== --- /dev/null +++ data/pgroonga-textsearch-pg-trgm/index-creation.tsv 2016-11-17 11:56:43 +0900 (a4d61b0) @@ -0,0 +1,2 @@ +PGroonga textsearch pg\\_trgm +1.4 2.9 1.8 Added: images/pgroonga-textsearch-pg-trgm/index-creation.svg (+195 -0) 100644 =================================================================== --- /dev/null +++ images/pgroonga-textsearch-pg-trgm/index-creation.svg 2016-11-17 11:56:43 +0900 (088633a) @@ -0,0 +1,195 @@ +<?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='M89.9,449.4 L575.0,449.4 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M89.9,449.4 M575.0,449.4 '/> <g transform="translate(81.6,453.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='M89.9,380.3 L575.0,380.3 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M89.9,380.3 M575.0,380.3 '/> <g transform="translate(81.6,384.2)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 0.5</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='M89.9,311.2 L575.0,311.2 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M89.9,311.2 M575.0,311.2 '/> <g transform="translate(81.6,315.1)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 1</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='M89.9,242.0 L575.0,242.0 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M89.9,242.0 M575.0,242.0 '/> <g transform="translate(81.6,245.9)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 1.5</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='M89.9,172.9 L575.0,172.9 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M89.9,172.9 M575.0,172.9 '/> <g transform="translate(81.6,176.8)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 2</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='M89.9,103.8 L575.0,103.8 '/></g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <path stroke='black' d='M89.9,103.8 M575.0,103.8 '/> <g transform="translate(81.6,107.7)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 2.5</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='M89.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='M89.9,34.7 M575.0,34.7 '/> <g transform="translate(81.6,38.6)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="end"> + <text><tspan font-family="Arial" > 3</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,242.1) rotate(270)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Elapsed time (hour)</tspan></text> + </g> + <g transform="translate(35.0,242.1) rotate(270)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >(Shorter is better)</tspan></text> + </g> +</g> +<g fill="none" color="black" stroke="currentColor" stroke-width="1.00" stroke-linecap="butt" stroke-linejoin="miter"> + <g transform="translate(332.4,471.3)" stroke="none" fill="black" font-family="Arial" font-size="12.00" text-anchor="middle"> + <text><tspan font-family="Arial" >Module</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(186.8,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 = '152.9,22.5 178.5,22.5 178.5,13.5 152.9,13.5 '/> + </g> + <path stroke='black' d='M152.9,22.5 L178.5,22.5 L178.5,13.5 L152.9,13.5 L152.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(173, 127, 168)' points = '244.5,449.4 299.2,449.4 299.2,255.8 244.5,255.8 '/> + </g> + <path stroke='black' d='M244.5,449.4 L244.5,255.9 L299.1,255.9 L299.1,449.4 L244.5,449.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(312.0,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 = '278.1,22.5 303.7,22.5 303.7,13.5 278.1,13.5 '/> + </g> + <path stroke='black' d='M278.1,22.5 L303.7,22.5 L303.7,13.5 L278.1,13.5 L278.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( 52, 101, 164)' points = '305.2,449.4 359.8,449.4 359.8,48.4 305.2,48.4 '/> + </g> + <path stroke='black' d='M305.2,449.4 L305.2,48.5 L359.7,48.5 L359.7,449.4 L305.2,449.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(437.2,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 = '403.3,22.5 428.9,22.5 428.9,13.5 403.3,13.5 '/> + </g> + <path stroke='black' d='M403.3,22.5 L428.9,22.5 L428.9,13.5 L403.3,13.5 L403.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( 78, 154, 6)' points = '365.8,449.4 420.5,449.4 420.5,200.5 365.8,200.5 '/> + </g> + <path stroke='black' d='M365.8,449.4 L365.8,200.6 L420.4,200.6 L420.4,449.4 L365.8,449.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> + -------------- next part -------------- HTML����������������������������...下載
