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

[Simon Poole]

I would suggest that https://switch2osm.org/ is the only place you will 
have at least a fighting chance of people seeing your text.

Anywhere else it wills be just be drowned out by 100s of decade old, 
irrelevant, but better ranked, search results from google (and a similar 
argument applies for the wiki, essentially small variations in the 
search terms are going to turn up lots of nonsense).

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 495 bytes
Desc: OpenPGP digital signature
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20210507/235c314f/attachment.sig>