v12, brin, btree

[gevel.git] / sql / gevel_brin.sql

diff --git a/sql/gevel_brin.sql b/sql/gevel_brin.sql
new file mode 100644 (file)
index 0000000..2382378
--- /dev/null
+++ b/sql/gevel_brin.sql
@@ -0,0 +1,14 @@
+SET client_min_messages = warning;
+\set ECHO none
+\i gevel.brin.sql
+\set ECHO all
+RESET client_min_messages;
+
+CREATE TABLE gevelb ( t box );
+\copy gevelb from 'data/rect.data'
+
+--BRIN
+CREATE INDEX brin_idx ON gevelb USING brin ( t );
+
+SELECT brin_stat('brin_idx');
+SELECT brin_print('brin_idx');