OpenMapTiles benchmark

openmaptiles-benchmark.md

Taro's vm on mac

spec

• macbook pro 2018 + pararell desktop pro
• 8 cpu
• 16GB Memory
• Ubuntu 20.04

results

• albania z0-z7

real	5m3.373s
user	0m13.296s
sys	0m2.771s

• japan z0-z14

real	3362m17.930s
user	0m53.366s
sys	1m0.301s

Taro's server

spec

• Deskmini A300
• AMD Ryzen 5 3400G with Radeon Vega Graphics
• 32GB Memory
• Intel SSDPEKNW010T8X1
• Debian GNU/Linux 10.5

result (1356d724d4d077f1d9c7db037542262ebb113eef)

• albania z0-z7

real    3m36.429s
user    0m13.802s
sys     0m2.020s

• japan z0-z14

real    3134m25.348s
user    0m14.877s
sys     0m1.927s

tuning

• albania z0-z7
• command: postgres -c autovacuum=off

real    3m16.827s
user    0m14.164s
sys     0m1.899s

• albania z0-z7
• command: postgres -c autovacuum=off
• sudo sysctl -w vm.dirty_ratio=3
• sudo sysctl -w vm.dirty_background_ratio=1

real    3m15.094s
user    0m13.877s
sys     0m2.037s

pgquery

• albania z0-z7

real    3m40.403s
user    0m14.324s
sys     0m1.766s

• albania z0-z14

./quickstart.sh  38.55s user 5.62s system 1% cpu 1:05:21.19 total

• albania z0-z14 + pgtune's setting

./quickstart.sh  38.91s user 4.83s system 1% cpu 1:05:34.72 total

• albania z0-z14 + postgresql 12 + postgis 3

./quickstart.sh  37.58s user 5.53s system 1% cpu 57:56.20 total

• japan z0-z14 + postgresql 12 + postgis 3

./quickstart.sh japan  65.12s user 36.44s system 0% cpu 19:06:17.45 total