mirror of
https://github.com/HypoPG/hypopg
synced 2026-05-23 17:18:44 +00:00
19 lines
462 B
MySQL
19 lines
462 B
MySQL
|
-- Hypothetical BRIN index tests
|
||
|
|
|
||
|
|
CREATE TABLE hypo_brin (id integer);
|
||
|
|
|
||
|
|
INSERT INTO hypo_brin SELECT generate_series(1, 10000);
|
||
|
|
|
||
|
|
ANALYZE hypo_brin;
|
||
|
|
|
||
|
|
SELECT COUNT(*) AS nb
|
||
|
|
FROM public.hypopg_create_index('CREATE INDEX ON hypo_brin USING brin (id);');
|
||
|
|
|
||
|
|
|
||
|
|
-- Should use hypothetical index
|
||
|
|
SET enable_seqscan = 0;
|
||
|
|
SELECT COUNT(*) FROM do_explain('SELECT * FROM hypo_brin WHERE id = 1') e
|
||
|
|
WHERE e ~ 'Bitmap Index Scan on <\d+>brin_hypo_brin.*';
|
||
|
|
|
||
|
|
DROP TABLE hypo_brin;
|