menthion Daria as one of aouthors

[gevel.git] / sql / gevel.sql

diff --git a/sql/gevel.sql b/sql/gevel.sql
index 50bf184..b9262ff 100644 (file)
--- a/sql/gevel.sql
+++ b/sql/gevel.sql
@@ -8,13 +8,23 @@ RESET client_min_messages;
 CREATE TABLE gevelt ( t box );
 \copy gevelt from 'data/rect.data'
 
+SELECT center(t) AS p INTO gevelp FROM gevelt;
+
 CREATE INDEX gist_idx ON gevelt USING gist ( t );
+CREATE INDEX spgist_idx ON gevelp USING spgist ( p );
+CREATE INDEX kdspgist_idx ON gevelp USING spgist ( p kd_point_ops);
 
 --GiST
 SELECT gist_stat('gist_idx');
 SELECT gist_tree('gist_idx');
 SELECT * FROM gist_print('gist_idx') as t(level int, valid bool, a box) where level=1;
 
+--SPGiST
+SELECT spgist_stat('spgist_idx');
+SELECT * FROM spgist_print('kdspgist_idx') as t(tid tid, allthesame bool, node_n int, level int, tid_pointer tid, prefix float8, node_label int, leaf_value point);
+SELECT * FROM spgist_print('spgist_idx') as t(tid tid, allthesame bool, node_n int, level int, tid_pointer tid, prefix point, node_label int, leaf_value point) WHERE level = 1;
+
+--GIN
 CREATE TABLE test__int( a int[] );
 \copy test__int from 'data/test__int.data'
 
@@ -22,5 +32,5 @@ CREATE INDEX gin_idx ON test__int USING gin ( a );
 
 INSERT INTO test__int ( SELECT ARRAY[t] || '{1000}'::_int4 FROM generate_series (1,300) as t );
 INSERT INTO test__int ( SELECT ARRAY[t] || '{1001}'::_int4 FROM generate_series (1,300) as t, generate_series(1,12) );
-VACUUM ANALYZE test__int; 
+VACUUM ANALYZE test__int;
 SELECT * FROM gin_stat('gin_idx') as t(value int, nrow int);