2
CREATE TABLE inettmp (a inet);
3
\copy inettmp from 'data/inet.data'
5
SELECT count(*) FROM inettmp WHERE a < '89.225.196.191';
11
SELECT count(*) FROM inettmp WHERE a <= '89.225.196.191';
17
SELECT count(*) FROM inettmp WHERE a = '89.225.196.191';
23
SELECT count(*) FROM inettmp WHERE a >= '89.225.196.191';
29
SELECT count(*) FROM inettmp WHERE a > '89.225.196.191';
35
CREATE INDEX inetidx ON inettmp USING gist ( a );
36
SET enable_seqscan=off;
37
SELECT count(*) FROM inettmp WHERE a < '89.225.196.191'::inet;
43
SELECT count(*) FROM inettmp WHERE a <= '89.225.196.191'::inet;
49
SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet;
55
SELECT count(*) FROM inettmp WHERE a >= '89.225.196.191'::inet;
61
SELECT count(*) FROM inettmp WHERE a > '89.225.196.191'::inet;
68
-- gist_inet_ops lacks a fetch function, so this should not be index-only scan
70
SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet;
72
--------------------------------------------------------
74
-> Bitmap Heap Scan on inettmp
75
Recheck Cond: (a = '89.225.196.191'::inet)
76
-> Bitmap Index Scan on inetidx
77
Index Cond: (a = '89.225.196.191'::inet)
80
SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet;
87
CREATE INDEX ON inettmp USING gist (a gist_inet_ops, a inet_ops);
88
-- likewise here (checks for core planner bug)
90
SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet;
92
--------------------------------------------------------
94
-> Bitmap Heap Scan on inettmp
95
Recheck Cond: (a = '89.225.196.191'::inet)
96
-> Bitmap Index Scan on inettmp_a_a1_idx
97
Index Cond: (a = '89.225.196.191'::inet)
100
SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet;