<!DOCTYPE html> <html> <head> </head> <body> <dl style="line-height: 1.5; margin-left: 2em"> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt> <dd style="margin-left: 8.5em">Kouhei Sutou <kou****@clear*****></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt> <dd style="margin-left: 8.5em">2015-10-30 11:46:20 +0900 (Fri, 30 Oct 2015)</dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt> <dd style="margin-left: 8.5em"><a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b">e559157f7be74eea3968b091f9cae84aacefd75b</a></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt> <dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">Add PGroogna 1.0.0 release announce</pre></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Added files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ce">en/_posts/2015-10-29-pgroonga-1.0.0.md</a></li> </ul> </dd> </dl> <div class="diff-section" style="clear: both"> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: en/_posts/2015-10-29-pgroonga-1.0.0.md (+107 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ce">...</a>                                                                                                                                                                                                                       </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ce">...</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR1">1</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR2">2</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR3">3</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR4">4</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR5">5</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR6">6</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR7">7</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR8">8</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR9">9</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR10">10</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR11">11</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR12">12</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR13">13</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR14">14</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR15">15</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR16">16</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR17">17</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR18">18</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR19">19</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR20">20</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR21">21</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR22">22</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR23">23</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR24">24</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR25">25</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR26">26</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR27">27</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR28">28</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR29">29</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR30">30</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR31">31</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR32">32</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR33">33</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR34">34</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR35">35</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR36">36</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR37">37</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR38">38</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR39">39</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR40">40</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR41">41</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR42">42</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR43">43</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR44">44</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR45">45</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR46">46</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR47">47</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR48">48</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR49">49</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR50">50</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR51">51</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR52">52</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR53">53</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR54">54</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR55">55</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR56">56</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR57">57</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR58">58</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR59">59</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR60">60</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR61">61</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR62">62</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR63">63</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR64">64</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR65">65</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR66">66</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR67">67</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR68">68</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR69">69</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR70">70</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR71">71</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR72">72</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR73">73</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR74">74</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR75">75</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR76">76</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR77">77</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR78">78</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR79">79</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR80">80</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR81">81</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR82">82</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR83">83</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR84">84</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR85">85</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR86">86</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR87">87</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR88">88</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR89">89</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR90">90</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR91">91</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR92">92</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR93">93</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR94">94</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR95">95</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR96">96</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR97">97</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR98">98</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR99">99</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR100">100</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR101">101</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR102">102</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR103">103</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR104">104</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR105">105</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR106">106</a> <a href="https://github.com/groonga/groonga.org/commit/e559157f7be74eea3968b091f9cae84aacefd75b#diff-6a63460b98bb65910abdea04a56bc0ceR107">107</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,107 @@ +--- +layout: post.en +title: PGroonga 1.0.0 has been released +description: PGroonga 1.0.0 has been released! +--- + +## PGroonga 1.0.0 has been released + +PGroonga (píːzí:lúnɡά) 1.0.0 has been released! It's the first major release! + +### About PGroonga + +PGroonga is a PostgreSQL extension that makes PostgreSQL fast full text search platform for all languages! + +There are some PostgreSQL extensions that improves full text search feature of PostgreSQL such as [pg_trgm](http://www.postgresql.org/docs/current/static/pgtrgm.html) and [pg_bigm](http://pgbigm.osdn.jp/index_en.html). + +pg\_trgm doesn't support languages that use non-alphanumerics characters such as Japanese and Chinese. + +pg\_bigm supports languages that use non-alphanumerics characters but it's slow. + +PGroonga supports all languages, provides rich full text search related features and is very fast. Because PGroonga uses [Groonga](http://groonga.org/) that is a full-fledged full text search engine as backend. + +For example, PGroonga is a few times faster than pg\_bigm. In some cases, PGroonga is 10 times over faster than pg\_bigm. + +Here are benchmark results between PGroonga and pg\_bigm. They use Japanese Wikipedia data. + +Here is a benchmark result for creating an index: + +Extension | Index creation time +-----------|-------------------- +PGroonga | 25m 37s +pg_bigm | 5h 56m 15s + +In this case, PGroonga is about 14 times faster than pg\_bigm. + +Here is a benchmark result for full text search: + +Search keywords | N hits | PGroonga | pg\_bigm +---------------------------------------|----------|------------|--------- +"PostgreSQL" or "MySQL" | 368 | *0.030s* | 0.107s +データベース (database in Japanese) | 17172 | *0.121s* | 1.224s +テレビアニメ (TV animation in Japanese) | 22885 | *0.179s* | 2.472s +日本 (Japan in Japanese) | 625792 | 0.646s | *0.556s* + +In "日本" (Japan in Japanese) case, pg\_bigm is a bit faster(\*) than PGroonga. But PGroonga is 3 times to 14 times faster than pg\_bigm in other cases. The result shows that PGroonga can perform stable high performance fast full text search against all keywords. + +(\*) pg\_bigm can perform faster full text search against keywords that have 2 or less characters rather than keywords that have 3 or more characters. + +PGroonga provides the following features that aren't provided by other extensions: + + * Normalize feature + * Custom tokenizer feature + * Snippet feature + +Normalize feature is a feature that converts different notation texts to unified notation text. + +For simple example, both "ABC" and "abc" are converted to "abc". + +For more complex example, both "ﾎﾟｽｸﾞﾚ" (HALFWIDTH KATAKANA) and "ポスグレ" (FULLWIDTH KATAKANA) are converted to "ポスグレ" (FULLWIDTH KATAKANA). ("ポスグレ" is an abbreviation of PostgreSQL in Japanese.) + +This normalization is based on [Unicode NFKC](http://unicode.org/reports/tr15/). + +Custom tokenizer feature is a feature that customizes search keyword extraction process (tokenization). If you can custom tokenization, you can control trade-off between search precision and search performance. + +For example, if you use "tokenizer that is based of morphological analyzer", you can get better search precision and search performance but may not find some texts. + +FYI: There is no other extension that supports morphological analyzer based tokenizer. PGroonga is the only extension that supports it. + +Snippet feature is a feature that shows texts around keyword. It's used by Web search engine. Google also uses it. You can find it under page title in hit page list. PGroonga provides a function that implements it. + +There are more features: + + * Query language that uses Web search engine like syntax + * JSON search + * You can use each value for condition. You can also perform full text search against all texts in JSON. No other extension such as [JsQuery](https://github.com/postgrespro/jsquery) doesn't provide full text search feature against JSON. + +Here are features that will be implemented in the feature. They are already implemented in Groonga. + + * Query expansion feature + * Weight feature + * Stemming feature + +### Usage + +You can use PGroonga without full text search knowledge. You just create an index and puts a condition into `WHERE`: + +```sql +CREATE INDEX index_name ON table USING pgroonga (column); + +SELECT * FROM table WHERE column @@ 'PostgreSQL'; +``` + +You can also use `LIKE` to use PGroonga. PGroonga provides a feature that performs `LIKE` with index. `LIKE` with PGroonga index is faster than `LIKE` without index. It means that you can improve performance without changing your application that uses the following SQL: + +```sql +SELECT * FROM table WHERE column LIKE '%PostgreSQL%'; +``` + +Are you interested in PGroonga? Please [install](http://pgroonga.github.io/install/) and try [tutorial](http://pgroonga.github.io/tutorial/). You can know all PGroonga features. + +You can install PGroonga easily. Because PGroonga provides packages for major platforms. There are binaries for Windows. + +## Conclusion + +New PGroonga version has been released. PGroonga is a PostgreSQL extension that makes PostgreSQL fast full text search platform for all languages. + +It's the first major release. If you want to use fast full text search for all langauges on PostgreSQL, try PGroonga! </pre> </td> </tr> </tbody> </table> </div> </body> </html>