Hello,

I've set up my own tile server (as in the tutorial on the https://switch2osm.org/manually-building-a-tile-server-18-04-lts/) and now I have a few questions about optimization (I guess).

So, the main question is, does the render time:

renderd[5037]: DEBUG: START TILE ajt 17 71632-71639 43864-43871, new metatile renderd[5037]: DEBUG: DONE TILE ajt 17 71632-71639 43864-43871 in 3.534 seconds

include the time that's needed by postgres to complete the queries:

execution time 2038.937 ms, query: SELECT ST_AsBinary("way") AS geom,"feature","link","service" FROM (SELECT way, (CASE WHEN feature IN ('highway_motorway_link', 'highway_trunk_link', 'highway_prima ry_link', 'highway_secondary_link', 'highway_tertiary_link') THEN substr(feature, 0, length(feat ure)-4) ELSE feature END) AS feature, [...]

If yes, then if there's better CartoCss version that has queries optimized for the better indices usage?

asked 19 Aug, 15:27

januzi's gravatar image

januzi
563
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×81
×23

question asked: 19 Aug, 15:27

question was seen: 73 times

last updated: 19 Aug, 15:27

powered by OSQA