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

[Yuri Astrakhan]

You may also look at the OpenMapTiles database setup [1], and related [2]
GCP PG startup script that does some perf optimizations. These
optimizations are tuned towards to batch MVT tile generation (using
ST_AsMVT), but should also be applicable for realtime tilegen.

[1]
https://github.com/openmaptiles/openmaptiles-tools/blob/master/docs/database.md
[2]
https://github.com/openmaptiles/openmaptiles-tools/blob/master/docs/gcp_startup.sh

On Thu, May 6, 2021 at 3:59 PM Stephan Knauss <osm at stephans-server.de>
wrote:

> 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 --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20210506/0d80c60b/attachment.htm>