[Tile-serving] [osm2pgsql] Use unlogged tables during import (#350)

Paul Norman notifications at github.com
Wed May 13 17:56:51 UTC 2015


While importing the render tables are first created as an intermediate step, then the final tables are created with a `CREATE TABLE ... AS SELECT * FROM ...` SQL statement. The tables created as an intermediate step could be created as unlogged, as there is no value in them if PostgreSQL crashes mid-import as the import needs to be restarted anyways, and they do not need to be propagated to replicas.

This would be easier if support for 9.0 was dropped, as unlogged tables were added in 9.1.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/350
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150513/dfcca04b/attachment.html>


More information about the Tile-serving mailing list