1CREATE TABLESPACE fast LOCATION '@TMP_DIR@/space';
2CREATE TABLE memos (
3  id integer,
4  content text
5);
6INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');
7INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.');
8INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');
9CREATE INDEX pgrn_index ON memos USING pgroonga (content) TABLESPACE fast;
10VACUUM;
11SET enable_seqscan = off;
12SET enable_indexscan = on;
13SET enable_bitmapscan = off;
14SELECT id, content
15  FROM memos
16 WHERE content %% 'PGroonga' AND content %% 'Groonga';
17 id |                        content
18----+-------------------------------------------------------
19  3 | PGroonga is a PostgreSQL extension that uses Groonga.
20(1 row)
21
22DROP TABLE memos;
23DROP TABLESPACE fast;
24