Skip to content

Instantly share code, notes, and snippets.

@smellman

smellman/omt_benchmark.txt

Last active February 6, 2021 11:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save smellman/49244ae13fe23ff43d51544cd82c6087 to your computer and use it in GitHub Desktop.
Save smellman/49244ae13fe23ff43d51544cd82c6087 to your computer and use it in GitHub Desktop.
Download ZIP
OpenMapTiles Bench Mark
Raw
omt_benchmark.txt
```
+ # pgtune + dw
+ command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.9 -c wal_buffers=16MB -c default_statistics_target=500 -c random_page_cost=1.1 -c effective_io_concurrency=200 -c work_mem=26214kB -c min_wal_size=4GB -c max_wal_size=16GB -c max_worker_processes=8 -c max_parallel_workers_per_gather=4
+ # pgtune + oltp
+ # command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.9 -c wal_buffers=16MB -c default_statistics_target=100 -c random_page_cost=1.1 -c effective_io_concurrency=200 -c work_mem=52428kB -c min_wal_size=2GB -c max_wal_size=8GB -c max_worker_processes=8 -c max_parallel_workers_per_gather=4
+ # pgtune + web
+ # command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.7 -c wal_buffers=16MB -c default_statistics_target=100 -c random_page_cost=1.1 -c effective_io_concurrency=200 -c work_mem=52428kB -c min_wal_size=1GB -c max_wal_size=4GB -c max_worker_processes=8 -c max_parallel_workers_per_gather=4
```
OMT + pgquery + Japan z0-z14
It takes 137401 seconds to complete
OMT + pgquery + NO_GZIP + USE_KEY + Japan z0-z14
It takes 138277 seconds to complete
OMT + pgquery + NO_GZIP + USE_KEY + asia z0-z14
The ./quickstart.sh asia is finished!
It takes 1922563 seconds to complete
OMT + pgquery + NO_GZIP + USE_KEY + Japan z0-z14 + pgtune(dw)
The ./quickstart.sh japan is finished!
It takes 116687 seconds to complete
OMT + pgquery + NO_GZIP + USE_KEY + Japan z0-z14 + pgtune(OLTP)
The ./quickstart.sh japan is finished!
It takes 118324 seconds to complete
OMT + pgquery + pgtune + NO_ZIP + USE_KEY + asia z0-z14
The ./quickstart.sh asia is finished!
It takes 1972869 seconds to complete
OMT + pgquery + NO_GZIP + USE_KEY + Japan z0-z14 + pgtune(web)
The ./quickstart.sh japan is finished!
It takes 119143 seconds to complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment