Changes between Initial Version and Version 1 of Ticket #3753, comment 8
- Timestamp:
- 05/14/17 02:46:42 (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #3753, comment 8
initial v1 8 8 SELECT setseed(.43); 9 9 10 create table dataTable as select ST_MakePoint(x/1000,y/1000 ) c from generate_series(1,1e1,1)x, generate_series(1,1e1,1) y, generate_series(1,1e1,2) z;10 create table dataTable as select ST_MakePoint(x/1000,y/1000, z/1000) c from generate_series(1,1e1,1)x, generate_series(1,1e1,1) y, generate_series(1,1e1,2) z; 11 11 12 12 \timing on … … 17 17 select pg_size_pretty(pg_relation_size('idx')); 18 18 19 \timing off 20 19 21 drop table datatable; 22 23 commit; 20 24 }}}