1 SET client_min_messages = warning;
5 RESET client_min_messages;
8 CREATE TABLE gevelt ( t box );
9 \copy gevelt from 'data/rect.data'
11 CREATE INDEX gist_idx ON gevelt USING gist ( t );
14 SELECT gist_stat('gist_idx');
15 SELECT gist_tree('gist_idx');
16 SELECT * FROM gist_print('gist_idx') as t(level int, valid bool, a box) where level=1;
18 CREATE TABLE test__int( a int[] );
19 \copy test__int from 'data/test__int.data'
21 CREATE INDEX gin_idx ON test__int USING gin ( a );
23 INSERT INTO test__int ( SELECT ARRAY[t] || '{1000}'::_int4 FROM generate_series (1,300) as t );
24 INSERT INTO test__int ( SELECT ARRAY[t] || '{1001}'::_int4 FROM generate_series (1,300) as t, generate_series(1,12) );
26 SELECT * FROM gin_stat('gin_idx') as t(value int, nrow int);