[OSM-dev] OSM tile server: concurrency of rendering + updating

[Frederik Ramm]

Jon,

Jon Burgess wrote:
> I use a single DB on the tile server but perform the full import into a
> new set of tables. The replication diffs are applied into the main
> tables roughly once per minute in parallel with any rendering. 

[...]

Thank you for that in-depth report. I have put this on 
http://wiki.openstreetmap.org/wiki/Minutely_Mapnik for easier reference 
(I trust that if there's a better suited Wiki page someone will move it 
there).

> During the full planet import I will import the data into a new set of
> tables with the renderer accessing the old data. 

How often do you do this? Only when the osm2pgsql configuration changes 
to make it necessary, or routinely from time to time (does osm2pgsql 
still have the tendency to break multipolygons on incremental updates)?

Bye
Frederik