I've a little problem showing map tiles. My website during development/testing was using OSM, but we will going to production, and we want to serve the tiles without using OSM server no more.
Using the slippy map example, sometimes the tiles are rendered, and sometimes are not rendered, or take big time. May you help me? This is my configuration:
==Server Machine==
2 Cores, 10 Gb of RAM, inside a XenServer 6.2, using Ubuntu 14.04.2 LTS, Postgres, Postgis and Apache binaries get from Ubuntu Repository. Mapnik, Mod_tile and Renderd are last version compiled from source. I've followed the guide on Switch2Osm.
==Postgres.conf==
max_connections = 300
ssl = true
shared_buffers = 128MB
work_mem = 4096
maintenance_work_mem = 256MB
fsync = off
synchronous_commit = off
full_page_writes = on
wal_buffers = 16MB
checkpoint_segments = 1600
checkpoint_timeout = 10min
checkpoint_completion_target = 0.9
random_page_cost = 1.1
effective_cache_size = 9GBlog_min_duration_statement = 0
log_line_prefix = '%t '
log_timezone = 'localtime'autovacuum = on
== Planet.osm ==
Imported whole file
== Indexes created ==
http://wiki.openstreetmap.org/wiki/User:Species/PostGIS_Tuning plus the osm2psql standard ones
== Style ==
Unmodifed OSMBright (just the connection parameters)
== From log:
If I put this:
explain SELECT ST_AsBinary("way") AS geom,"admin_level" FROM ( SELECT way, admin_level FROM planet_osm_line WHERE boundary = 'administrative' AND admin_level IN ('2','3','4')) AS data WHERE "way" && ST_SetSRID('BOX3D(-20037508.34 -20037508.34,20037508.34 20037508.34)'::box3d, 900913)
(One of the first queries that taked a long time executing)
Seq Scan on planet_osm_line (cost=0.00..5871950.84 rows=2176 width=279) Filter: ((way && '010300002031BF0D000100000005000000D7A37045F81B73C1D7A37045F81B73C1D7A37045F81B73C1D7A37045F81B7341D7A37045F81B7341D7A37045F81B7341D7A37045F81B7341D7A37045F81B73C1D7A37045F81B73C1D7A37045F81B73C1'::geometry) AND (boundary = 'administrative'::text) AND (admin_level = ANY ('{2,3,4}'::text[])))
Why seq scan? Are there index I could build for OSM Bright?Thank you for all the info!
أكثر...
Using the slippy map example, sometimes the tiles are rendered, and sometimes are not rendered, or take big time. May you help me? This is my configuration:
==Server Machine==
2 Cores, 10 Gb of RAM, inside a XenServer 6.2, using Ubuntu 14.04.2 LTS, Postgres, Postgis and Apache binaries get from Ubuntu Repository. Mapnik, Mod_tile and Renderd are last version compiled from source. I've followed the guide on Switch2Osm.
==Postgres.conf==
max_connections = 300
ssl = true
shared_buffers = 128MB
work_mem = 4096
maintenance_work_mem = 256MB
fsync = off
synchronous_commit = off
full_page_writes = on
wal_buffers = 16MB
checkpoint_segments = 1600
checkpoint_timeout = 10min
checkpoint_completion_target = 0.9
random_page_cost = 1.1
effective_cache_size = 9GBlog_min_duration_statement = 0
log_line_prefix = '%t '
log_timezone = 'localtime'autovacuum = on
== Planet.osm ==
Imported whole file
== Indexes created ==
http://wiki.openstreetmap.org/wiki/User:Species/PostGIS_Tuning plus the osm2psql standard ones
== Style ==
Unmodifed OSMBright (just the connection parameters)
== From log:
If I put this:
explain SELECT ST_AsBinary("way") AS geom,"admin_level" FROM ( SELECT way, admin_level FROM planet_osm_line WHERE boundary = 'administrative' AND admin_level IN ('2','3','4')) AS data WHERE "way" && ST_SetSRID('BOX3D(-20037508.34 -20037508.34,20037508.34 20037508.34)'::box3d, 900913)
(One of the first queries that taked a long time executing)
Seq Scan on planet_osm_line (cost=0.00..5871950.84 rows=2176 width=279) Filter: ((way && '010300002031BF0D000100000005000000D7A37045F81B73C1D7A37045F81B73C1D7A37045F81B73C1D7A37045F81B7341D7A37045F81B7341D7A37045F81B7341D7A37045F81B7341D7A37045F81B73C1D7A37045F81B73C1D7A37045F81B73C1'::geometry) AND (boundary = 'administrative'::text) AND (admin_level = ANY ('{2,3,4}'::text[])))
Why seq scan? Are there index I could build for OSM Bright?Thank you for all the info!
أكثر...