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