[OSM-dev] Where to document recommendations for PostgreSQL regarding rendering

[Andy Townsend]

On 07/05/2021 08:46, Simon Poole wrote:
> I would suggest that https://switch2osm.org/ is the only place you 
> will have at least a fighting chance of people seeing your text.
>
> ...

I'd suggest a new page at this level:

https://github.com/switch2osm/switch2osm.github.io/tree/master/serving-tiles

I don't think it makes sense to confuse "totally new" people with this 
level of information (that was one of my reservations with 
https://github.com/switch2osm/switch2osm.github.io/pull/148 ), but it 
absolutely makes sense as a separate page.

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).

Best Regards,

Andy

> Am 06.05.2021 um 21:52 schrieb Stephan Knauss:
>> Hello fellow developers,
>>
>> where would be a good location to document settings to tune on 
>> PostgreSQL when setting up a rendering database?
>>
>> There is a section within osm2pgsql, but maintainers hint that this 
>> might not be such a good location for settings potentially relevant 
>> for rendering.
>>
>> https://github.com/openstreetmap/osm2pgsql-website/pull/12
>>
>> In the wiki I found a page about PostgreSQL tuning, but this hints 
>> towards storing OSM data as per API access:
>>
>> https://wiki.openstreetmap.org/wiki/PostgreSQL
>>
>>
>> I have not found any mentioning of database settings in 
>> openstreetmap-carto. Could that be a location to store such details?
>>
>> https://github.com/gravitystorm/openstreetmap-carto/blob/master/INSTALL.md 
>>
>>
>>
>> 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.
>>
>> 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.
>>
>> Stephan
>>
>>
>>
>> _______________________________________________
>> dev mailing list
>> dev at openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/dev
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20210507/4766f3ac/attachment.htm>