<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<div class="moz-cite-prefix">On 07/05/2021 08:46, Simon Poole wrote:<br>
</div>
<blockquote type="cite"
cite="mid:59a54d59-b188-9612-9a3f-f77d7fc661e8@poole.ch">I would
suggest that <a class="moz-txt-link-freetext" href="https://switch2osm.org/">https://switch2osm.org/</a> is the only place you will
have at least a fighting chance of people seeing your text.
<br>
<br>
...<br>
</blockquote>
<p>I'd suggest a new page at this level:<br>
</p>
<p><a class="moz-txt-link-freetext" href="https://github.com/switch2osm/switch2osm.github.io/tree/master/serving-tiles">https://github.com/switch2osm/switch2osm.github.io/tree/master/serving-tiles</a></p>
<p>I don't think it makes sense to confuse "totally new" people with
this level of information (that was one of my reservations with
<a class="moz-txt-link-freetext" href="https://github.com/switch2osm/switch2osm.github.io/pull/148">https://github.com/switch2osm/switch2osm.github.io/pull/148</a> ), but
it absolutely makes sense as a separate page.</p>
<p>It should contain clear and concise steps that someone running a
"large" database for the first time will need to do, rather than a
wide-ranging discussion of various performance aspects (there may
be a place for the latter elsewhere, of course).<br>
</p>
<p>Best Regards,</p>
<p>Andy<br>
</p>
<blockquote type="cite"
cite="mid:59a54d59-b188-9612-9a3f-f77d7fc661e8@poole.ch">Am
06.05.2021 um 21:52 schrieb Stephan Knauss:
<br>
<blockquote type="cite">Hello fellow developers,
<br>
<br>
where would be a good location to document settings to tune on
PostgreSQL when setting up a rendering database?
<br>
<br>
There is a section within osm2pgsql, but maintainers hint that
this might not be such a good location for settings potentially
relevant for rendering.
<br>
<br>
<a class="moz-txt-link-freetext" href="https://github.com/openstreetmap/osm2pgsql-website/pull/12">https://github.com/openstreetmap/osm2pgsql-website/pull/12</a>
<br>
<br>
In the wiki I found a page about PostgreSQL tuning, but this
hints towards storing OSM data as per API access:
<br>
<br>
<a class="moz-txt-link-freetext" href="https://wiki.openstreetmap.org/wiki/PostgreSQL">https://wiki.openstreetmap.org/wiki/PostgreSQL</a>
<br>
<br>
<br>
I have not found any mentioning of database settings in
openstreetmap-carto. Could that be a location to store such
details?
<br>
<br>
<a class="moz-txt-link-freetext" href="https://github.com/gravitystorm/openstreetmap-carto/blob/master/INSTALL.md">https://github.com/gravitystorm/openstreetmap-carto/blob/master/INSTALL.md</a>
<br>
<br>
<br>
I am thinking of content similar to what is within the osm2pgsql
manual, probably starting with a copy and focusing on aspects of
map rendering.
<br>
<br>
Especially the memory leak with PostgreSQL 12+ and using jit
while rendering and the additional load impact of parallel
workers without benefit seems worth to document. These are
default settings of PostgreSQL and need adjustment.
<br>
<br>
Stephan
<br>
<br>
<br>
<br>
_______________________________________________
<br>
dev mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.openstreetmap.org/listinfo/dev">https://lists.openstreetmap.org/listinfo/dev</a>
<br>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="https://lists.openstreetmap.org/listinfo/dev">https://lists.openstreetmap.org/listinfo/dev</a>
</pre>
</blockquote>
</body>
</html>