Changes between Version 1 and Version 2 of Ticket #3753, comment 8


Ignore:
Timestamp:
05/14/17 03:08:30 (8 years ago)
Author:
robe

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #3753, comment 8

    v1 v2  
    88SELECT setseed(.43);
    99
    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;
     10create table dataTable as select ST_MakePoint(x/1000,y/1000, z/1000) c from generate_series(1,1e2,1)x, generate_series(1,1e2,1) y, generate_series(1,100000,1000) z;
    1111
    1212\timing on
    … …  
    1616
    1717select pg_size_pretty(pg_relation_size('idx'));
     18\set timing off
     19drop table datatable;
     20}}}
    1821
    19 \timing off
    2022
    21 drop table datatable;
     23I did only 2 runs for 3d, but not seeing an improvement
    2224
    23 commit;
     25index size in both is 79 MB
     26
     27
     28{{{
     29PostGIS 2.3
     30
     31first run:
     32
     33   Time: 13461.306 ms
     34    Time: 24551.813 ms
     35    Time: 3.859 ms
     36    Time: 1.549 ms
     37    Time: 121.835 ms
     38   
     39second run:
     40
     41    Time: 13694.926 ms
     42    Time: 24591.686 ms
     43    Time: 4.425 ms
     44    Time: 1.634 ms
     45    Time: 117.875 ms
     46   
     47 
     48   
     49PostGIS 2.4
     50
     51first run:
     52
     53    Time: 15111.942 ms
     54    Time: 23063.534 ms
     55    Time: 3.645 ms
     56    Time: 8.082 ms
     57    Time: 104.651 ms
     58
     59second run:
     60
     61    Time: 14967.676 ms
     62    Time: 25793.583 ms
     63    Time: 4.122 ms
     64    Time: 2.091 ms
     65    Time: 107.363 ms
    2466}}}