245
245
| (5.1,34.5) | (10,10) | 24.9851956166046
248
-- Test that GiST indexes provide same behavior as sequential scan
249
CREATE TEMP TABLE point_gist_tbl(f1 point);
250
INSERT INTO point_gist_tbl SELECT '(0,0)' FROM generate_series(0,1000);
251
CREATE INDEX point_gist_tbl_index ON point_gist_tbl USING gist (f1);
252
INSERT INTO point_gist_tbl VALUES ('(0.0000009,0.0000009)');
253
SET enable_seqscan TO true;
254
SET enable_indexscan TO false;
255
SET enable_bitmapscan TO false;
256
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000009,0.0000009)'::point;
262
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 <@ '(0.0000009,0.0000009),(0.0000009,0.0000009)'::box;
268
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000018,0.0000018)'::point;
274
SET enable_seqscan TO false;
275
SET enable_indexscan TO true;
276
SET enable_bitmapscan TO true;
277
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000009,0.0000009)'::point;
283
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 <@ '(0.0000009,0.0000009),(0.0000009,0.0000009)'::box;
289
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000018,0.0000018)'::point;
295
RESET enable_seqscan;
296
RESET enable_indexscan;
297
RESET enable_bitmapscan;