1 SET client_min_messages = warning;
3 RESET client_min_messages;
4 CREATE TABLE gevelb ( t box );
5 \copy gevelb from 'data/rect.data'
7 CREATE INDEX brin_idx ON gevelb USING brin ( t );
8 SELECT brin_stat('brin_idx');
10 ------------------------------------
11 Number of revmap pages: 1 +
12 Number of empty revmap pages: 0 +
13 Number of regular pages: 1 +
16 Free space 8104 bytes+
20 SELECT brin_print('brin_idx');
22 --------------------------------------------------------
23 Start block: 0; end block: 24; offset: 113, free: 1704+