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