[Tile-serving] [openstreetmap/osm2pgsql] Why so slow, even after upgrading to full SSD system and doubling RAM to 32Gb? (#883)

[mdadduzio]

@mboeringa : About lowest tiling levels: I see, and what you say makes senses.
I'll experiment with higher levels and see. Thanks for the insight.

About cleaning: I'll follow your advice and re-do it more carefully paying attention to smaller and thinner dust sediments which, I admit, I didn't care much when I cleaned it last time since I was used to more noticeable amounts of dirt and dust you usually find inside notebooks.
I agree with you: my impression is that, although well cooled, those gaming notebooks are at their very limits when full throttling (especially about heating) and that a tiny glitch may be well enough to make them fail.
Thanks again for help.

@anybody: What are usually good times/performance for planet-size osm2pgsql imports, but even more importantly for renderd/mapnik real time on demand tiling?
Any advices/hints about HW/SW configurations?

Would my notebook (with its HW configuration detailed in my first thread message) be enough for one or maximum two local LAN OSM tiles consumer clients at high level tiles ***acceptable real-time*** requests (having previously tiles & cached the first 11 (0-10) level tiles for example)?
For acceptable real-time I mean less than a second per tile o even better. 

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/883#issuecomment-445469117
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20181208/4fcc352c/attachment.html>