-
Notifications
You must be signed in to change notification settings - Fork 2
/
postgis_indexing_script.sql
70 lines (54 loc) · 1.23 KB
/
postgis_indexing_script.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
\pset footer off
SET client_min_messages TO WARNING;
\set ON_ERROR_STOP ON
\echo
\echo 'setting up experiment tables'
\i postgis_indexing_setup.sql
\echo
\echo 'Set variables for tests'
SELECT ST_AsBinary(ST_MakeEnvelope(20.2619773, 43.618682, 30.0454257, 48.2653964, 4326)) AS test_area
\gset
\echo
\echo '1st experiment: 100.000 points'
\set npoints 100000
\i points.sql
\echo
\echo '2nd experiment: 1.000.000 points'
\set npoints 1000000
\i points.sql
\echo
\echo '3rd experiment: 10.000.000 points'
\set npoints 10000000
\i points.sql
\echo
\echo '4th experiment: 100.000.000 points'
\set npoints 100000000
\i points.sql
\echo
\echo '5th experiment: 1.000.000.000 points'
\set npoints 1000000000
\i points.sql
\echo
\echo 'finished point experiments'
\echo
\echo '6th experiment: 100.000 lines'
\set npoints 100000
\i linestrings.sql
\echo
\echo '7th experiment: 1.000.000 lines'
\set npoints 1000000
\i linestrings.sql
\echo
\echo '8th experiment: 10.000.000 lines'
\set npoints 10000000
\i linestrings.sql
\echo
\echo '9th experiment: 100.000.000 lines'
\set npoints 100000000
\i linestrings.sql
\echo
\echo '10th experiment: 1.000.000.000 lines'
\set npoints 1000000000
\i linestrings.sql
\echo
\echo 'finished linestring experiments'