[Tile-serving] [openstreetmap/osm2pgsql] smart use of "unlogged tables" with postgres 9.5+ (#626)
cquest
notifications at github.com
Thu Oct 6 06:54:31 UTC 2016
Given that:
1. using unlogged tables during import is much faster
2. unlogged tables are not crash-safe
3. Postgres 9.5 and above allows to switch tables from unlogged to logged tables (and reverse).
When osm2pgsql imports on PG 9.5+, it could be interesting to use unlogged table by default during import, then switch them back to logged tables at the end of import.
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/626
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20161005/b11114cc/attachment.html>
More information about the Tile-serving
mailing list