[Tile-serving] [openstreetmap/osm2pgsql] tuning the postgres part (#823)

Sarah Hoffmann notifications at github.com
Thu Feb 15 08:34:09 UTC 2018


The last stage only reorders table in postges and create indexes. It is independent of the cache from -C.

What version of osm2pgsql are you using? The releasing of memory should have been fixed very recently in #813. You should now be able to have a high -C for the import stage and  configure also a very high `maintenance_work_mem` in postgres to speed up the indexing stage a bit.

-- 
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/823#issuecomment-365857841
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20180215/b24ed3ff/attachment.html>


More information about the Tile-serving mailing list