1CREATE TABLE ids ( 2 id integer 3); 4INSERT INTO ids VALUES (2); 5INSERT INTO ids VALUES (7); 6INSERT INTO ids VALUES (6); 7INSERT INTO ids VALUES (4); 8INSERT INTO ids VALUES (5); 9INSERT INTO ids VALUES (8); 10INSERT INTO ids VALUES (1); 11INSERT INTO ids VALUES (10); 12INSERT INTO ids VALUES (3); 13INSERT INTO ids VALUES (9); 14CREATE INDEX pgroonga_index ON ids 15 USING pgroonga (id pgroonga.int4_ops); 16SET enable_seqscan = off; 17SET enable_indexscan = on; 18SET enable_bitmapscan = off; 19SELECT id 20 FROM ids 21 WHERE id IN (6, 1, 7) 22 ORDER BY id ASC; 23 id 24---- 25 1 26 6 27 7 28(3 rows) 29 30DROP TABLE ids; 31