Kouhei Sutou
null+****@clear*****
Fri Nov 4 00:53:25 JST 2016
Kouhei Sutou 2016-11-04 00:53:25 +0900 (Fri, 04 Nov 2016) New Revision: 92ffabc5c9e7affd333340f4d543689f3756b8d9 https://github.com/pgroonga/pgroonga.github.io/commit/92ffabc5c9e7affd333340f4d543689f3756b8d9 Message: Use https for www.postgresql.org Modified files: _po/ja/news/index.po _po/ja/overview/index.po _po/ja/reference/create-index-using-pgroonga.po _po/ja/reference/functions/pgroonga-command.po _po/ja/reference/grant-usage-on-schema-pgroonga.po _po/ja/reference/operators/jsonb-contain.po _po/ja/reference/operators/jsonb-query.po _po/ja/reference/operators/like.po _po/ja/reference/operators/regular-expression.po _po/ja/reference/parameters/log_type.po _po/ja/reference/pgroonga-versus-gist-and-gin.po _po/ja/tutorial/index.po _po/ja/upgrade/index.po ja/news/index.md ja/reference/create-index-using-pgroonga.md ja/reference/index.md overview/index.md reference/create-index-using-pgroonga.md reference/functions/pgroonga-command.md reference/grant-usage-on-schema-pgroonga.md reference/operators/jsonb-contain.md reference/operators/jsonb-query.md reference/operators/like.md reference/operators/regular-expression.md reference/parameters/log_type.md reference/pgroonga-versus-gist-and-gin.md tutorial/index.md upgrade/index.md Modified: _po/ja/news/index.po (+52 -7) =================================================================== --- _po/ja/news/index.po 2016-11-04 00:46:58 +0900 (aa35a93) +++ _po/ja/news/index.po 2016-11-04 00:53:25 +0900 (a6a5428) @@ -20,20 +20,68 @@ msgstr "" msgid "# News" msgstr "# おしらせ" -msgid "## 1.1.5: 2016-10-22 {#version-1-1-5}" +msgid "## 1.1.7: 2016-11-03 {#version-1-1-7}" +msgstr "" + +msgid "### Fixes" +msgstr "### 修正" + +msgid " * Fixed build error with PostgreSQL 9.4 or earlier." +msgstr "" + +msgid "## 1.1.6: 2016-11-03 {#version-1-1-6}" msgstr "" msgid "### Improvements" msgstr "### 改良" +msgid " * [[Windows](../install/windows.html)] Upgraded bundled Groonga to 6.1.0." +msgstr "" + +msgid "" +" * [experimental][WAL] Supported WAL. WAL support requires PostgreSQL 9.6 or " +"later and [MessagePack](http://msgpack.org/). WAL support means that you can u" +"se PostgreSQL's [stream replication feature](https://www.postgresql.org/docs/{" +"{ site.postgresql_short_version }}/static/warm-standby.html) but doesn't mean " +"that PGroonga is crash safe. If PostgreSQL crashes while updating PGroonga dat" +"a, PGroonga data may be broken. See also [replication](../reference/replicatio" +"n.html) and [`pgroonga.enable_wal` parameter][../reference/parameters/enable_w" +"al.html]." +msgstr "" + +msgid " * Upgraded required Groonga version to 6.0.7 or later." +msgstr "" + +msgid "" +" * Supported [tablespace](https://www.postgresql.org/docs/{{ site.postgresql_" +"short_version }}/static/manage-ag-tablespaces.html)." +msgstr "" + +msgid "" +" * Disabled index only scan automatically when there is one or more long reco" +"rds." +msgstr "" + +msgid "" +" * Fixed a bug that living PGroonga indexes are removed on VACUUM when PGroon" +"ga index is created at non default tablespace. [GitHub#27][Reported by pavelpo" +"povgmail]" +msgstr "" + +msgid "### Thanks" +msgstr "### 感謝" + +msgid " * pavelpopovgmail" +msgstr "" + +msgid "## 1.1.5: 2016-10-22 {#version-1-1-5}" +msgstr "" + msgid "" " * [[Windows](../install/windows.html)] Provided PostgreSQL 9.5 package again" "." msgstr "" -msgid "### Fixes" -msgstr "### 修正" - msgid "" " * [`&?>` operator](../reference/operators/query-contain-v2.html) Fixed a bug" " that it may return `true` even if it's not matched." @@ -49,9 +97,6 @@ msgid "" "xed a memory leak. [groonga-dev,04154][Reported by Takahashi]" msgstr "" -msgid "### Thanks" -msgstr "### 感謝" - msgid " * Takahashi" msgstr "" Modified: _po/ja/overview/index.po (+2 -2) =================================================================== --- _po/ja/overview/index.po 2016-11-04 00:46:58 +0900 (6c28f19) +++ _po/ja/overview/index.po 2016-11-04 00:53:25 +0900 (5af71f4) @@ -61,8 +61,8 @@ msgid "" msgstr "あらゆる言語をサポートした全文検索を実現するための拡張機能がいくつかあります。" msgid "" -" * [pg_trgm](http://www.postgresql.org/docs/{{ site.postgresql_short_version " -"}}/static/pgtrgm.html)\n" +" * [pg_trgm](https://www.postgresql.org/docs/{{ site.postgresql_short_version" +" }}/static/pgtrgm.html)\n" " * It's bundled with PostgreSQL but it's not installed as default.\n" " * You need to change pg\\_trgm source code to support all languages." msgstr "" Modified: _po/ja/reference/create-index-using-pgroonga.po (+39 -3) =================================================================== --- _po/ja/reference/create-index-using-pgroonga.po 2016-11-04 00:46:58 +0900 (4314da3) +++ _po/ja/reference/create-index-using-pgroonga.po 2016-11-04 00:53:25 +0900 (af05893) @@ -32,9 +32,9 @@ msgstr "## 構文" msgid "" "This section describes only `pgroonga` index method related `CREATE INDEX` syn" -"tax. See [`CREATE INDEX` document by PostgreSQL](http://www.postgresql.org/doc" -"s/{{ site.postgresql_short_version }}/static/sql-createindex.html) for full `C" -"REATE INDEX` syntax." +"tax. See [`CREATE INDEX` document by PostgreSQL](https://www.postgresql.org/do" +"cs/{{ site.postgresql_short_version }}/static/sql-createindex.html) for full `" +"CREATE INDEX` syntax." msgstr "" "このセクションでは`pgroonga`インデックスメソッド関連の`CREATE INDEX`の構文だけ説明します。完全な`CREATE INDEX`の構文は" "[PostgreSQLの`CREATE INDEX`のドキュメント](http://www.postgresql.jp/document/{{ site.p" @@ -241,3 +241,39 @@ msgid "" msgstr "" "他のノーマライザーについては[ノーマライザー](http://groonga.org/ja/docs/reference/normalizers.html)" "を参照してください。" + +msgid "#### How to change tablespace {#custom-tablespace}" +msgstr "" + +msgid "Since 1.1.6." +msgstr "" + +msgid "" +"Specify `TABLESPACE ${TABLESPACE_NAME}` for customizing [tablespace](https://w" +"ww.postgresql.org/docs/{{ site.postgresql_short_version }}/static/manage-ag-ta" +"blespaces.html). If you have fast storage, you may want to change tablespace f" +"or PGroonga indexes." +msgstr "" + +msgid "Here is an example to change tablespace:" +msgstr "" + +msgid "" +"```sql\n" +"CREATE TABLESPACE fast LOCATION '/data/fast_disk';" +msgstr "" + +msgid "" +"CREATE TABLE memos (\n" +" id integer,\n" +" tag text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_tag_index\n" +" ON memos\n" +" USING pgroonga (tag)\n" +" TABLESPACE fast;\n" +"```" +msgstr "" Modified: _po/ja/reference/functions/pgroonga-command.po (+2 -2) =================================================================== --- _po/ja/reference/functions/pgroonga-command.po 2016-11-04 00:46:58 +0900 (57c1143) +++ _po/ja/reference/functions/pgroonga-command.po 2016-11-04 00:53:25 +0900 (21a0ebd) @@ -50,8 +50,8 @@ msgstr "`command`は`text`型の値です。`pgroonga.command`は`command`をGro msgid "" "Groonga command returns result as JSON. `pgroonga.command` returns the JSON as" " `text` type value. You can use [JSON functions and operations provided by Pos" -"tgreSQL](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/st" -"atic/functions-json.html) by casting the result to `json` or `jsonb` type." +"tgreSQL](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/s" +"tatic/functions-json.html) by casting the result to `json` or `jsonb` type." msgstr "" "Groongaのコマンドは結果をJSONとして返します。`pgroonga.command`はJSONを`text`型の値として返します。結果を`json`" "型か`jsonb`型にキャストすると[PostgreSQLが提供するJSON関数・演算](http://www.postgresql.jp/document" Modified: _po/ja/reference/grant-usage-on-schema-pgroonga.po (+5 -5) =================================================================== --- _po/ja/reference/grant-usage-on-schema-pgroonga.po 2016-11-04 00:46:58 +0900 (df55ab7) +++ _po/ja/reference/grant-usage-on-schema-pgroonga.po 2016-11-04 00:53:25 +0900 (d6f76e2) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2016-02-11 11:53+0900\n" +"PO-Revision-Date: 2016-11-04 00:52+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -36,8 +36,8 @@ msgid "## Create a normal user {#create-user}" msgstr "## 一般ユーザーを作成 {#create-user}" msgid "" -"First, create a normal user `alice` by [`CREATE USER`](http://www.postgresql.o" -"rg/docs/{{ site.postgresql_short_version }}/static/sql-createuser.html):" +"First, create a normal user `alice` by [`CREATE USER`](https://www.postgresql." +"org/docs/{{ site.postgresql_short_version }}/static/sql-createuser.html):" msgstr "" "最初に[`CREATE USER`](http://www.postgresql.jp/document/{{ site.postgresql_short_" "version }}/html/sql-createuser.html)で一般ユーザー`alice`を作成します。" @@ -73,8 +73,8 @@ msgstr "## `pgroonga`スキーマの`USAGE`権限を与える {#grant}" msgid "" "You can grant `USAGE` privilege on `pgroonga` schema to normal user `alice` by" -" [`GRANT`](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/" -"static/sql-grant.html):" +" [`GRANT`](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}" +"/static/sql-grant.html):" msgstr "" "[`GRANT`](http://www.postgresql.jp/document/{{ site.postgresql_short_version }" "}/html/sql-grant.html)を使って一般ユーザー`alice`に`pgroonga`スキーマの`USAGE`権限を与えることができます。" Modified: _po/ja/reference/operators/jsonb-contain.po (+7 -7) =================================================================== --- _po/ja/reference/operators/jsonb-contain.po 2016-11-04 00:46:58 +0900 (7b1e9dd) +++ _po/ja/reference/operators/jsonb-contain.po 2016-11-04 00:53:25 +0900 (b44d151) @@ -27,10 +27,10 @@ msgid "PGroonga supports fast index search by `@>` operator." msgstr "PGroongaは`@>`演算子の検索をインデックスを使って高速に実現できます。" msgid "" -"[`@>` operator is a built-in PostgreSQL operator](http://www.postgresql.org/do" -"cs/{{ site.postgresql_short_version }}/static/functions-json.html#FUNCTIONS-JS" -"ONB-OP-TABLE). `@>` operator returns true when the right hand side `jsonb` typ" -"e value is a subset of left hand side `jsonb` type value." +"[`@>` operator is a built-in PostgreSQL operator](https://www.postgresql.org/d" +"ocs/{{ site.postgresql_short_version }}/static/functions-json.html#FUNCTIONS-J" +"SONB-OP-TABLE). `@>` operator returns true when the right hand side `jsonb` ty" +"pe value is a subset of left hand side `jsonb` type value." msgstr "" "[`@>`演算子はPostgreSQL組み込みの演算子](http://www.postgresql.jp/document/{{ site.postgre" "sql_short_version }}/html/functions-json.html#FUNCTIONS-JSONB-OP-TABLE)です。`@>`" @@ -120,9 +120,9 @@ msgid "Here is an example for match case:" msgstr "マッチする例は次の通りです。" msgid "" -"(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/stat" -"ic/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since Postgre" -"SQL 9.5 for readability.)" +"(It uses [`jsonb_pretty()` function](https://www.postgresql.org/docs/devel/sta" +"tic/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since Postgr" +"eSQL 9.5 for readability.)" msgstr "" "（読みやすくするためにPostgreSQL 9.5以降で使える[`jsonb_pretty()`関数](http://www.postgresql.jp/d" "ocument/current/html/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE)を使ってい" Modified: _po/ja/reference/operators/jsonb-query.po (+3 -3) =================================================================== --- _po/ja/reference/operators/jsonb-query.po 2016-11-04 00:46:58 +0900 (de96d29) +++ _po/ja/reference/operators/jsonb-query.po 2016-11-04 00:53:25 +0900 (2bfc98c) @@ -278,9 +278,9 @@ msgid "" msgstr "次は`www.example.com`という文字列値を含む`jsonb`型の値を検索する条件です。" msgid "" -"(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/stat" -"ic/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since Postgre" -"SQL 9.5 for readability.)" +"(It uses [`jsonb_pretty()` function](https://www.postgresql.org/docs/devel/sta" +"tic/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since Postgr" +"eSQL 9.5 for readability.)" msgstr "" "（読みやすくするためにPostgreSQL 9.5以降で使える[`jsonb_pretty()`関数](http://www.postgresql.jp/d" "ocument/current/html/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE)を使ってい" Modified: _po/ja/reference/operators/like.po (+4 -4) =================================================================== --- _po/ja/reference/operators/like.po 2016-11-04 00:46:58 +0900 (69d9e03) +++ _po/ja/reference/operators/like.po 2016-11-04 00:53:25 +0900 (114992a) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2016-01-01 22:57+0900\n" +"PO-Revision-Date: 2016-11-04 00:50+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -33,9 +33,9 @@ msgstr "" msgid "" "`column LIKE '%KEYWORD%'` with index is slower than `column %% 'KEYWORD'` with" -" index because `column LIKE '%KEYWORD%'` with index needs \"[Recheck](http://ww" -"w.postgresql.org/docs/{{ site.postgresql_short_version }}/static/index-scannin" -"g.html)\". `column %% 'KEYWORD'` doesn't need \"Recheck\"." +" index because `column LIKE '%KEYWORD%'` with index needs \"[Recheck](https://w" +"ww.postgresql.org/docs/{{ site.postgresql_short_version }}/static/index-scanni" +"ng.html)\". `column %% 'KEYWORD'` doesn't need \"Recheck\"." msgstr "" "インデックスを使った`column LIKE '%キーワード%'`は`column %% 'キーワード'`よりも遅いです。これは、インデックスを使った`co" "lumn LIKE '%キーワード%'`は「[再検査](https://www.postgresql.jp/document/{{ site.postgre" Modified: _po/ja/reference/operators/regular-expression.po (+4 -4) =================================================================== --- _po/ja/reference/operators/regular-expression.po 2016-11-04 00:46:58 +0900 (f5cf9fc) +++ _po/ja/reference/operators/regular-expression.po 2016-11-04 00:53:25 +0900 (2ce1a30) @@ -30,15 +30,15 @@ msgid "PostgreSQL provides the following built-in regular expression operators:" msgstr "PostgreSQLは次のような組み込みの正規表現演算子を提供しています。" msgid "" -" * [`SIMILAR TO`](http://www.postgresql.org/docs/{{ site.postgresql_short_ver" -"sion }}/static/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP)" +" * [`SIMILAR TO`](https://www.postgresql.org/docs/{{ site.postgresql_short_ve" +"rsion }}/static/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP)" msgstr "" " * [`SIMILAR TO`](http://www.postgresql.jp/document/{{ site.postgresql_short_" "version }}/html/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP)" msgid "" -" * [POSIX Regular Expression](http://www.postgresql.org/docs/{{ site.postgres" -"ql_short_version }}/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP)" +" * [POSIX Regular Expression](https://www.postgresql.org/docs/{{ site.postgre" +"sql_short_version }}/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP)" msgstr "" " * [POSIX正規表現](http://www.postgresql.jp/document/{{ site.postgresql_short_ver" "sion }}/html/functions-matching.html#FUNCTIONS-POSIX-REGEXP)" Modified: _po/ja/reference/parameters/log_type.po (+2 -2) =================================================================== --- _po/ja/reference/parameters/log_type.po 2016-11-04 00:46:58 +0900 (ea8dd17) +++ _po/ja/reference/parameters/log_type.po 2016-11-04 00:53:25 +0900 (6cca841) @@ -119,8 +119,8 @@ msgid "" msgstr "" msgid "" -"See also [Registering Event Log on Windows](http://www.postgresql.org/docs/{{ " -"site.postgresql_short_version }}/static/event-log-registration.html)." +"See also [Registering Event Log on Windows](https://www.postgresql.org/docs/{{" +" site.postgresql_short_version }}/static/event-log-registration.html)." msgstr "" "[WindowsにおけるEvent Logの登録](http://www.postgresql.jp/document/{{ site.postgresql" "_short_version }}/html/event-log-registration.html)も参照してください。" Modified: _po/ja/reference/pgroonga-versus-gist-and-gin.po (+6 -5) =================================================================== --- _po/ja/reference/pgroonga-versus-gist-and-gin.po 2016-11-04 00:46:58 +0900 (3ddded0) +++ _po/ja/reference/pgroonga-versus-gist-and-gin.po 2016-11-04 00:53:25 +0900 (0dd8058) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2015-10-24 10:06+0900\n" +"PO-Revision-Date: 2016-11-04 00:51+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -46,10 +46,11 @@ msgid "## Characteristics" msgstr "## 特徴" msgid "" -"[PostgreSQL document describes about characteristics of GiST and GIN](http://w" -"ww.postgresql.org/docs/{{ site.postgresql_short_version }}/static/textsearch-i" -"ndexes.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." +"[PostgreSQL document describes about characteristics of GiST and GIN](https://" +"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" +"." msgstr "" "[PostgreSQLのドキュメントはGiSTとGINの特徴を説明](http://www.postgresql.jp/document/{{ site.p" "ostgresql_short_version }}/html/textsearch-indexes.html)しています。手短にまとめると次の通りです。G" Modified: _po/ja/tutorial/index.po (+11 -11) =================================================================== --- _po/ja/tutorial/index.po 2016-11-04 00:46:58 +0900 (1e7733b) +++ _po/ja/tutorial/index.po 2016-11-04 00:53:25 +0900 (9a0b2e5) @@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2016-09-08 15:57+0900\n" +"PO-Revision-Date: 2016-11-04 00:51+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -465,9 +465,9 @@ msgstr "この関数はすべてのテキストに対して使うことができ msgid "" "Here is a sample SQL that describes about it. You can use the function in the " -"following `SELECT` that doesn't have `FROM`. Note that [`unnest`](http://www.p" -"ostgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-array." -"html) is a PostgreSQL function that converts an array to rows." +"following `SELECT` that doesn't have `FROM`. Note that [`unnest`](https://www." +"postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-array" +".html) is a PostgreSQL function that converts an array to rows." msgstr "" "この挙動を説明するサンプルSQLは次の通りです。`FROM`がない次の`SELECT`でもこの関数を使えます。[`unnest`](http://www.p" "ostgresql.jp/document/{{ site.postgresql_short_version }}/html/functions-array" @@ -862,10 +862,10 @@ msgstr "" " * `@@`演算子" msgid "" -"[`@>` operator is a built-in PostgreSQL operator](http://www.postgresql.org/do" -"cs/{{ site.postgresql_short_version }}/static/functions-json.html#FUNCTIONS-JS" -"ONB-OP-TABLE). `@>` returns true when the right hand side `jsonb` is a subset " -"of left hand side `jsonb`." +"[`@>` operator is a built-in PostgreSQL operator](https://www.postgresql.org/d" +"ocs/{{ site.postgresql_short_version }}/static/functions-json.html#FUNCTIONS-J" +"SONB-OP-TABLE). `@>` returns true when the right hand side `jsonb` is a subset" +" of left hand side `jsonb`." msgstr "" "[`@>`演算子はPostgreSQL組み込みの演算子](http://www.postgresql.jp/document/{{ site.postgre" "sql_short_version }}/html/functions-json.html#FUNCTIONS-JSONB-OP-TABLE)です。`@>`" @@ -942,9 +942,9 @@ msgid "Here is an example:" msgstr "例です。" msgid "" -"(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/stat" -"ic/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since Postgre" -"SQL 9.5 for readability.)" +"(It uses [`jsonb_pretty()` function](https://www.postgresql.org/docs/devel/sta" +"tic/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since Postgr" +"eSQL 9.5 for readability.)" msgstr "" "（読みやすくするためにPostgreSQL 9.5以降で使える[`jsonb_pretty()`関数](http://www.postgresql.jp/d" "ocument/current/html/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE)を使ってい" Modified: _po/ja/upgrade/index.po (+6 -6) =================================================================== --- _po/ja/upgrade/index.po 2016-11-04 00:46:58 +0900 (a0af1cb) +++ _po/ja/upgrade/index.po 2016-11-04 00:53:25 +0900 (cc6354e) @@ -164,22 +164,22 @@ msgid "## See also" msgstr "## 参考" msgid "" -" * [`CREATE EXTENSION`](http://www.postgresql.org/docs/{{ site.postgresql_sho" -"rt_version }}/static/sql-createextension.html)" +" * [`CREATE EXTENSION`](https://www.postgresql.org/docs/{{ site.postgresql_sh" +"ort_version }}/static/sql-createextension.html)" msgstr "" " * [`CREATE EXTENSION`](http://www.postgresql.jp/document/{{ site.postgresql_" "short_version }}/html/sql-createextension.html)" msgid "" -" * [`DROP EXTENSION`](http://www.postgresql.org/docs/{{ site.postgresql_short" -"_version }}/static/sql-dropextension.html)" +" * [`DROP EXTENSION`](https://www.postgresql.org/docs/{{ site.postgresql_shor" +"t_version }}/static/sql-dropextension.html)" msgstr "" " * [`DROP EXTENSION`](http://www.postgresql.jp/document/{{ site.postgresql_sh" "ort_version }}/html/sql-dropextension.html)" msgid "" -" * [`ALTER EXTENSION`](http://www.postgresql.org/docs/{{ site.postgresql_shor" -"t_version }}/static/sql-alterextension.html)" +" * [`ALTER EXTENSION`](https://www.postgresql.org/docs/{{ site.postgresql_sho" +"rt_version }}/static/sql-alterextension.html)" msgstr "" " * [`ALTER EXTENSION`](http://www.postgresql.jp/document/{{ site.postgresql_s" "hort_version }}/html/sql-alterextension.html)" Modified: ja/news/index.md (+28 -0) =================================================================== --- ja/news/index.md 2016-11-04 00:46:58 +0900 (789e2d6) +++ ja/news/index.md 2016-11-04 00:53:25 +0900 (ba61cb6) @@ -4,6 +4,34 @@ title: おしらせ # おしらせ +## 1.1.7: 2016-11-03 {#version-1-1-7} + +### 修正 + + * Fixed build error with PostgreSQL 9.4 or earlier. + +## 1.1.6: 2016-11-03 {#version-1-1-6} + +### 改良 + + * [[Windows](../install/windows.html)] Upgraded bundled Groonga to 6.1.0. + + * [experimental][WAL] Supported WAL. WAL support requires PostgreSQL 9.6 or later and [MessagePack](http://msgpack.org/). WAL support means that you can use PostgreSQL's [stream replication feature](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/warm-standby.html) but doesn't mean that PGroonga is crash safe. If PostgreSQL crashes while updating PGroonga data, PGroonga data may be broken. See also [replication](../reference/replication.html) and [`pgroonga.enable_wal` parameter][../reference/parameters/enable_wal.html]. + + * Upgraded required Groonga version to 6.0.7 or later. + + * Supported [tablespace](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/manage-ag-tablespaces.html). + + * Disabled index only scan automatically when there is one or more long records. + +### 修正 + + * Fixed a bug that living PGroonga indexes are removed on VACUUM when PGroonga index is created at non default tablespace. [GitHub#27][Reported by pavelpopovgmail] + +### 感謝 + + * pavelpopovgmail + ## 1.1.5: 2016-10-22 {#version-1-1-5} ### 改良 Modified: ja/reference/create-index-using-pgroonga.md (+22 -0) =================================================================== --- ja/reference/create-index-using-pgroonga.md 2016-11-04 00:46:58 +0900 (5573f6d) +++ ja/reference/create-index-using-pgroonga.md 2016-11-04 00:53:25 +0900 (3d4cd7d) @@ -109,3 +109,25 @@ CREATE INDEX pgroonga_tag_index ``` 他のノーマライザーについては[ノーマライザー](http://groonga.org/ja/docs/reference/normalizers.html)を参照してください。 + +#### How to change tablespace {#custom-tablespace} + +Since 1.1.6. + +Specify `TABLESPACE ${TABLESPACE_NAME}` for customizing [tablespace](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/manage-ag-tablespaces.html). If you have fast storage, you may want to change tablespace for PGroonga indexes. + +Here is an example to change tablespace: + +```sql +CREATE TABLESPACE fast LOCATION '/data/fast_disk'; + +CREATE TABLE memos ( + id integer, + tag text +); + +CREATE INDEX pgroonga_tag_index + ON memos + USING pgroonga (tag) + TABLESPACE fast; +``` Modified: ja/reference/index.md (+2 -0) =================================================================== --- ja/reference/index.md 2016-11-04 00:46:58 +0900 (fe15ece) +++ ja/reference/index.md 2016-11-04 00:53:25 +0900 (99a2287) @@ -100,6 +100,8 @@ PGroonga 1.Y.Zは`pgroonga.XXX_v2`という演算子クラスを提供します * [`pgroonga.lock_timeout`パラメーター](parameters/lock_timeout.html) + * [`pgroonga.enable_wal` parameter](parameters/enable_wal.html) + ## チューニング 通常、PGroongaはデフォルトで高速に動くため、特別にPGroongaをチューニングする必要はありません。 Modified: overview/index.md (+1 -1) =================================================================== --- overview/index.md 2016-11-04 00:46:58 +0900 (e6de6ff) +++ overview/index.md 2016-11-04 00:53:25 +0900 (d3a83b8) @@ -16,7 +16,7 @@ And more, PGroonga supports full text search against all text values in JSON. It There are some extensions that implements full text search against all languages: - * [pg_trgm](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/pgtrgm.html) + * [pg_trgm](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/pgtrgm.html) * It's bundled with PostgreSQL but it's not installed as default. * You need to change pg\_trgm source code to support all languages. Modified: reference/create-index-using-pgroonga.md (+1 -1) =================================================================== --- reference/create-index-using-pgroonga.md 2016-11-04 00:46:58 +0900 (bb444c6) +++ reference/create-index-using-pgroonga.md 2016-11-04 00:53:25 +0900 (6d05760) @@ -8,7 +8,7 @@ You need to specify `USING pgroonga` to `CREATE INDEX` to use PGroonga as index ## Syntax -This section describes only `pgroonga` index method related `CREATE INDEX` syntax. See [`CREATE INDEX` document by PostgreSQL](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-createindex.html) for full `CREATE INDEX` syntax. +This section describes only `pgroonga` index method related `CREATE INDEX` syntax. See [`CREATE INDEX` document by PostgreSQL](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-createindex.html) for full `CREATE INDEX` syntax. Here is a basic syntax for creating a single column index: Modified: reference/functions/pgroonga-command.md (+1 -1) =================================================================== --- reference/functions/pgroonga-command.md 2016-11-04 00:46:58 +0900 (1bcaf47) +++ reference/functions/pgroonga-command.md 2016-11-04 00:53:25 +0900 (7c5ae9c) @@ -18,7 +18,7 @@ text pgroonga.command(command) `command` is a `text` type value. `pgroonga.command` executes `command` as a Groonga command. -Groonga command returns result as JSON. `pgroonga.command` returns the JSON as `text` type value. You can use [JSON functions and operations provided by PostgreSQL](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-json.html) by casting the result to `json` or `jsonb` type. +Groonga command returns result as JSON. `pgroonga.command` returns the JSON as `text` type value. You can use [JSON functions and operations provided by PostgreSQL](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-json.html) by casting the result to `json` or `jsonb` type. ## Usage Modified: reference/grant-usage-on-schema-pgroonga.md (+2 -2) =================================================================== --- reference/grant-usage-on-schema-pgroonga.md 2016-11-04 00:46:58 +0900 (b72fcc4) +++ reference/grant-usage-on-schema-pgroonga.md 2016-11-04 00:53:25 +0900 (03e8232) @@ -10,7 +10,7 @@ This document describes how to grant `USAGE` privilege on `pgroonga` schema to a ## Create a normal user {#create-user} -First, create a normal user `alice` by [`CREATE USER`](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-createuser.html): +First, create a normal user `alice` by [`CREATE USER`](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-createuser.html): ```sql CREATE USER alice; @@ -29,7 +29,7 @@ You need to grant `USAGE` privilege on `pgroonga` schema to `alice`. ## Grant `USAGE` privilege on `pgroonga` schema {#grant} -You can grant `USAGE` privilege on `pgroonga` schema to normal user `alice` by [`GRANT`](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-grant.html): +You can grant `USAGE` privilege on `pgroonga` schema to normal user `alice` by [`GRANT`](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-grant.html): ```sql GRANT USAGE ON SCHEMA pgroonga TO alice; Modified: reference/operators/jsonb-contain.md (+2 -2) =================================================================== --- reference/operators/jsonb-contain.md 2016-11-04 00:46:58 +0900 (4ae18f9) +++ reference/operators/jsonb-contain.md 2016-11-04 00:53:25 +0900 (5820c6a) @@ -8,7 +8,7 @@ title: "@> operator" PGroonga supports fast index search by `@>` operator. -[`@>` operator is a built-in PostgreSQL operator](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` operator returns true when the right hand side `jsonb` type value is a subset of left hand side `jsonb` type value. +[`@>` operator is a built-in PostgreSQL operator](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` operator returns true when the right hand side `jsonb` type value is a subset of left hand side `jsonb` type value. ## Syntax @@ -73,7 +73,7 @@ SET enable_seqscan = off; Here is an example for match case: -(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) +(It uses [`jsonb_pretty()` function](https://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) ```sql SELECT jsonb_pretty(record) FROM logs WHERE record @> '{"host": "www.example.com"}'::jsonb; Modified: reference/operators/jsonb-query.md (+1 -1) =================================================================== --- reference/operators/jsonb-query.md 2016-11-04 00:46:58 +0900 (ef2d997) +++ reference/operators/jsonb-query.md 2016-11-04 00:53:25 +0900 (fc0dc03) @@ -156,7 +156,7 @@ You specify condition that matches split value to `@@` operator. If there is one Here is a condition that searches `jsonb` type value that has `www.example.com` string: -(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) +(It uses [`jsonb_pretty()` function](https://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) ```sql SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'string == "www.example.com"'; Modified: reference/operators/like.md (+1 -1) =================================================================== --- reference/operators/like.md 2016-11-04 00:46:58 +0900 (1711242) +++ reference/operators/like.md 2016-11-04 00:53:25 +0900 (3fcc1f2) @@ -8,7 +8,7 @@ title: LIKE operator PGroonga converts `column LIKE '%KEYWORD%'` condition to `column %% 'KEYWORD'` internally. [`%%` operator](match.html) performs full text search with index. It's faster than `LIKE` operator without index. -`column LIKE '%KEYWORD%'` with index is slower than `column %% 'KEYWORD'` with index because `column LIKE '%KEYWORD%'` with index needs "[Recheck](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/index-scanning.html)". `column %% 'KEYWORD'` doesn't need "Recheck". +`column LIKE '%KEYWORD%'` with index is slower than `column %% 'KEYWORD'` with index because `column LIKE '%KEYWORD%'` with index needs "[Recheck](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/index-scanning.html)". `column %% 'KEYWORD'` doesn't need "Recheck". The original `LIKE` operator searches against text as is. But `%%` operator performs full text search against normalized text. It means that search result of `LIKE` operator with index needs "Recheck". Modified: reference/operators/regular-expression.md (+2 -2) =================================================================== --- reference/operators/regular-expression.md 2016-11-04 00:46:58 +0900 (29aa632) +++ reference/operators/regular-expression.md 2016-11-04 00:53:25 +0900 (aee309a) @@ -10,9 +10,9 @@ title: "@~ operator" PostgreSQL provides the following built-in regular expression operators: - * [`SIMILAR TO`](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP) + * [`SIMILAR TO`](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP) - * [POSIX Regular Expression](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP) + * [POSIX Regular Expression](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP) `SIMILAR TO` is based on SQL standard. "POSIX Regular Expression" is based on POSIX. They use different regular expression syntax. Modified: reference/parameters/log_type.md (+1 -1) =================================================================== --- reference/parameters/log_type.md 2016-11-04 00:46:58 +0900 (f98de25) +++ reference/parameters/log_type.md 2016-11-04 00:53:25 +0900 (8c5a2ed) @@ -62,7 +62,7 @@ You can suppress the warnings from Event Viewer by registering `PGroonga` event > regsvr32 /n /i:PGroonga ${PostgreSQL install folder}\lib\pgevent.dll ``` -See also [Registering Event Log on Windows](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/event-log-registration.html). +See also [Registering Event Log on Windows](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/event-log-registration.html). ## See also Modified: reference/pgroonga-versus-gist-and-gin.md (+1 -1) =================================================================== --- reference/pgroonga-versus-gist-and-gin.md 2016-11-04 00:46:58 +0900 (e7113f6) +++ reference/pgroonga-versus-gist-and-gin.md 2016-11-04 00:53:25 +0900 (1a88522) @@ -12,7 +12,7 @@ This document 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. +[PostgreSQL document describes about characteristics of GiST and GIN](https://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. Modified: tutorial/index.md (+4 -4) =================================================================== --- tutorial/index.md 2016-11-04 00:46:58 +0900 (ef5bbbd) +++ tutorial/index.md 2016-11-04 00:53:25 +0900 (0851653) @@ -215,7 +215,7 @@ Here is the result of `pgroonga.snippet_html` against the above text: This function can be used for all texts. It's not only for search result by PGroonga. -Here is a sample SQL that describes about it. You can use the function in the following `SELECT` that doesn't have `FROM`. Note that [`unnest`](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-array.html) is a PostgreSQL function that converts an array to rows. +Here is a sample SQL that describes about it. You can use the function in the following `SELECT` that doesn't have `FROM`. Note that [`unnest`](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-array.html) is a PostgreSQL function that converts an array to rows. ```sql SELECT unnest(pgroonga.snippet_html( @@ -460,7 +460,7 @@ PGroonga provides the following two operators for searching against `jsonb`: * `@>` operator * `@@` operator -[`@>` operator is a built-in PostgreSQL operator](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` returns true when the right hand side `jsonb` is a subset of left hand side `jsonb`. +[`@>` operator is a built-in PostgreSQL operator](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` returns true when the right hand side `jsonb` is a subset of left hand side `jsonb`. You can execute `@>` faster by PGroonga. @@ -519,7 +519,7 @@ SET enable_seqscan = off; Here is an example: -(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) +(It uses [`jsonb_pretty()` function](https://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) ```sql SELECT jsonb_pretty(record) FROM logs WHERE record @> '{"host": "www.example.com"}'::jsonb; @@ -556,7 +556,7 @@ Here is an example for range search. The `SELECT` returns records that is matche * `code` key exists at the top-level object * Value of the `code` is greater than or equal to `200` and less than `300` -(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) +(It uses [`jsonb_pretty()` function](https://www.postgresql.org/docs/devel/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since PostgreSQL 9.5 for readability.) ```sql SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'paths @ ".code" && number >= 200 && number < 300'; Modified: upgrade/index.md (+3 -3) =================================================================== --- upgrade/index.md 2016-11-04 00:46:58 +0900 (8f2b6c1) +++ upgrade/index.md 2016-11-04 00:53:25 +0900 (80dbf01) @@ -96,10 +96,10 @@ ALTER EXTENSION pgroonga UPDATE; ## See also - * [`CREATE EXTENSION`](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-createextension.html) + * [`CREATE EXTENSION`](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-createextension.html) - * [`DROP EXTENSION`](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-dropextension.html) + * [`DROP EXTENSION`](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-dropextension.html) - * [`ALTER EXTENSION`](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-alterextension.html) + * [`ALTER EXTENSION`](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-alterextension.html) * [`CREATE INDEX USING pgroonga`](../reference/create-index-using-pgroonga.html) -------------- next part -------------- HTML����������������������������...Télécharger
