Kouhei Sutou
null+****@clear*****
Thu Nov 3 17:48:33 JST 2016
Kouhei Sutou 2016-11-03 17:48:33 +0900 (Thu, 03 Nov 2016) New Revision: 5ef7bdaab10e9e504f1f53a296d179b33fe7fb54 https://github.com/pgroonga/pgroonga.github.io/commit/5ef7bdaab10e9e504f1f53a296d179b33fe7fb54 Message: Describe about customizing tablespace Modified files: reference/create-index-using-pgroonga.md Modified: reference/create-index-using-pgroonga.md (+22 -0) =================================================================== --- reference/create-index-using-pgroonga.md 2016-11-03 17:22:10 +0900 (f9df493) +++ reference/create-index-using-pgroonga.md 2016-11-03 17:48:33 +0900 (bb444c6) @@ -109,3 +109,25 @@ CREATE INDEX pgroonga_tag_index ``` See [Normalizers](http://groonga.org/docs/reference/normalizers.html) for other normalizers. + +#### 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; +``` -------------- next part -------------- HTML����������������������������... ダウンロード