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 USING pgroonga (id); 15SET enable_seqscan = off; 16SET enable_indexscan = off; 17SET enable_bitmapscan = on; 18SELECT id 19 FROM ids 20 WHERE id IN (6, 1, 7) 21 ORDER BY id ASC; 22 id 23---- 24 1 25 6 26 7 27(3 rows) 28 29DROP TABLE ids; 30