Kouhei Sutou
null+****@clear*****
Wed May 27 09:34:17 JST 2015
Kouhei Sutou 2015-05-27 09:34:17 +0900 (Wed, 27 May 2015) New Revision: 27387d7b8748fe8860fbc9f5bda3505751af229f https://github.com/pgroonga/pgroonga.github.io/commit/27387d7b8748fe8860fbc9f5bda3505751af229f Message: Tranlsate Added files: reference/pgroonga-versus-gist-and-gin.md Modified files: _config.yml tutorial/index.md Modified: _config.yml (+1 -0) =================================================================== --- _config.yml 2015-05-27 00:01:58 +0900 (9099a68) +++ _config.yml 2015-05-27 09:34:17 +0900 (af977b6) @@ -4,6 +4,7 @@ highlighter: pygments pgroonga_version: 0.5.0 pgroonga_release_date: 2015-04-29 copyright_year: 2015 +postgresql_short_version: 9.4 windows_postgresql_version: 9.4.1-3 exclude: ["Rakefile", "Gemfile", "Gemfile.lock"] description: A PostgreSQL plugin to use Groonga as index Added: reference/pgroonga-versus-gist-and-gin.md (+30 -0) 100644 =================================================================== --- /dev/null +++ reference/pgroonga-versus-gist-and-gin.md 2015-05-27 09:34:17 +0900 (0980c38) @@ -0,0 +1,30 @@ +--- +title: PGroonga versus GiST and GIN +layout: en +--- + +# PGroonga versus GiST and GIN + +PostgreSQL provides GiST and GIN as bundled indexes. PGroonga's main feature is CJK ready fast full text search. But PGroonga also provides general propose index features for equality condition and comparison conditions. You can use PGroonga as alternative of GiST and GIN. + +This documents describes about different between PGroonga, GiST and GIN. + +## Characteristics + +[PostgreSQL document describes about characteristics of GiST and GIN](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/textsearch-indexes.html). In short, searching by GiST is slower than searching by GIN but updating GiST is faster than updating GIN. GIN uses more disk space than GiST. + +Searching by PGroonga is faster than GIN and updating PGroonga is faster than GiST. But PGroonga uses more disk space than GIN and GiST. + +Here is a table that shows the above characteristics: + +Index | Search | Update | Disk usage +-------- | ----------- | ----------- | ---------- +GIN | Faster | Slower | Larger +GiST | Slower | Faster | Smaller +PGroonga | More faster | More faster | More larger + +## Benchmark + +This section shows these characteristics by sample data. + +TODO Modified: tutorial/index.md (+9 -7) =================================================================== --- tutorial/index.md 2015-05-27 00:01:58 +0900 (2c3487b) +++ tutorial/index.md 2015-05-27 09:34:17 +0900 (a3a32c1) @@ -3,17 +3,19 @@ title: Tutorial layout: en --- -## 使い方 +# Tutorial -PGroongaは全文検索はもちろん、数値や文字列の等価条件（`=`）や比較条件 -（`<`や`>=`など）にも使えます。 +This document describes how to use PGroonga step by step. If you don't install PGroonga yet, [install](../install/) PGroonga before you read this document. -まずは全文検索の使い方について説明し、次に等価条件や比較条件で使う方法 -を説明します。 +You can use PGroonga as fast full text search index. You can also use PGroonga as more general index for equality condition (`=`) and comparison conditions ('<', '>=' and so on). -### 全文検索 +PostgreSQL provides GiST and GIN as bundled indexes. You can use PGroonga as alternative of GiST and GIN. See [PGroonga versus GiST and GIN](../reference/pgroonga-versus-gist-and-gin.html) for differences of them. -#### 基本的な使い方 +This document describes about how to use PGroonga as full text search index then describes about how to use PGroonga as index for equality condition and comparison conditions. + +## Full text search + +### Basic usage `text`型のカラムを作って`pgroonga`インデックスを作成します。 （`varchar`型に対して全文検索をする場合は追加で -------------- next part -------------- HTML����������������������������...Download